I want to import a CSV file into cassandra. When I write this command on cassandra cqlsh, I got an error: command is: <pre class="prettyprint"><code>COPY table ( ID, name) FROM 'table.csv' WITH HEADER = TRUE; </code></pre> and the error: <pre class="prettyprint"><code>Can't open 'table.csv' for reading: [Errno 2] No such file or directory: 'table.csv' </code></pre> Can any one tell me what does it mean?

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.

Import .csv file into cassandra

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?

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.