Hi
I figured out the problem
my csv file looked like this
, ,test1 ,test2
Once I deleted the extra whitespace it is working now.
Thanks for your help
Search found 2 matches
- Mon Nov 26, 2012 7:32 pm
- Forum: Vertica Data Load
- Topic: Copy from CSV file to a Integer Column
- Replies: 3
- Views: 8288
- Mon Nov 26, 2012 3:43 pm
- Forum: Vertica Data Load
- Topic: Copy from CSV file to a Integer Column
- Replies: 3
- Views: 8288
Copy from CSV file to a Integer Column
Hello All, I have someting like this Create Table Sample( column 1 bigint, column 2 varchar, column 3 varchar) Data is , test1,test2 (note that first column is null) Copy command gives me error saying that invalid value for column integer, my copy command is copy schema.Sample from 'Table1.csv' deli...