Search found 2 matches

by avenirit
Mon Nov 26, 2012 7:32 pm
Forum: Vertica Data Load
Topic: Copy from CSV file to a Integer Column
Replies: 3
Views: 8288

Re: Copy from CSV file to a Integer Column

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
by avenirit
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...

Go to advanced search