Re: Bulk load in cassandra

2014-08-27 Thread Robert Coli
On Wed, Aug 27, 2014 at 5:13 AM, Malay Nilabh wrote: > I installed Cassandra on one node successfully using CLI I am able to > add a table to the keyspace as well as retrieve the data from the table. > My query is if I have text file on my local file system and I want to load > on Cassandra clu

Re: Bulk load in cassandra

2014-08-27 Thread Mark Reddy
Hi, You can use the COPY command to load in data from a local file, however it needs to be a csv formatted file. For more info see http://www.datastax.com/documentation/cql/3.0/cql/cql_reference/copy_r.html Regards, Mark On 27 August 2014 13:13, Malay Nilabh wrote: > Hi > > I installed Cass

Re: Bulk load in cassandra

2014-08-27 Thread baskar.duraikannu
Please try COPY command via CQL shell if it is delimited file. Regards, Baskar Duraikannu -Original Message- From: Malay Nilabh Date: Wed, 27 Aug 2014 17:43:21 To: user@cassandra.apache.org Reply-To: user@cassandra.apache.org Subject: Bulk load in cassandra Hi I installed Cassandra

Re: Bulk load in cassandra

2014-08-27 Thread Umang Shah
Hi Malay, Yesterday i answered for your question but you didn't replied back whether it worked for you or not. Anyways you mean by importing text file into cassandra. you can do that by following way. COPY keyspace.columnfamily (column1, column2,...) FROM 'temp.csv' (location of file); for dir

Bulk load in cassandra

2014-08-27 Thread Malay Nilabh
Hi I installed Cassandra on one node successfully using CLI I am able to add a table to the keyspace as well as retrieve the data from the table. My query is if I have text file on my local file system and I want to load on Cassandra cluster or you can say bulk load. How can I achieve that. Ple