CODEWITHSUNDEEP
cassandra
aaa
aaa

Reputation: 89

cassandra skip columns on copy data from csv file

I want to copy some columns from csv file to cassandra table. There's 300 columns in csv file and I only need the first ten columns. There's no header in the csv file. I tried

copy table from 'file.csv' with header=false and skipcols=[range(11,300)]

but it didn't work.

Upvotes: 0

Views: 648

Answers (1)

dbdoctor
dbdoctor

Reputation: 36

Can you specify column names after table name i.e.

COPY TABLE xx(c1,c2..C30) FROM ..

Upvotes: 1

Related Questions