Import .csv file into cassandra

Question

I want to import a CSV file into cassandra. When I write this command on cassandra cqlsh, I got an error: command is:

COPY table ( ID,  name) FROM 'table.csv' WITH HEADER = TRUE;

and the error:

Can't open 'table.csv' for reading: [Errno 2] No such file or directory: 'table.csv'

Can any one tell me what does it mean?

Answer 1

table.csv file should be in cassandra installation directory(where you run cqlsh).

File name is case senstive, so check with orginal file name case.