I am loading the data from a flat file into vertica database using copy command but copy command is giving me below error:-
ERROR: column reference "column_name" is ambiguous
where column_name is the just the name of the column e.g. customer_name.
Also I have checked that the column_name is not mentioned twice in my script.
Not sure why this error is coming, please help.
Copy command error
Moderator: NorbertKrupa
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Copy command error
Hi!
Can you post the description of the table you are loading and the actual COPY command?
Can you post the description of the table you are loading and the actual COPY command?
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.