Re: Better option to load data to cassandra

2014-11-13 Thread Shane Hansen
So sstableloader is a cpu efficient online method of loading data if you already have sstables. An option you may not have considered is just using batch inserts. It was a surprise to me coming from another database system, but C*'s primary use case is shoving data to an append only log. Is there

Re: Better option to load data to cassandra

2014-11-13 Thread Jonathan Lacefield
Here's another post which is pretty comprehensive for this topic. http://informationsurvival.blogspot.com/2014/02/cassandra-cql3-integration.html [image: datastax_logo.png] Jonathan Lacefield Solution Architect | (404) 822 3487 | jlacefi...@datastax.com [image: linkedin.png]

Re: Better option to load data to cassandra

2014-11-13 Thread Robert Coli
On Wed, Nov 12, 2014 at 5:19 PM, cass savy wrote: > Sstableloader works well for large tables if you want to move data from > Cassandra to Cassandra. This works if both C* are on the same version. > > Sstable2json and json2sstable is another alternative. > This post is getting a bit long in the t

Re: Better option to load data to cassandra

2014-11-12 Thread cass savy
Sstableloader works well for large tables if you want to move data from Cassandra to Cassandra. This works if both C* are on the same version. Sstable2json and json2sstable is another alternative. On Nov 11, 2014 4:53 AM, "srinivas rao" wrote: > Hi Team, > > Please suggest me the better options

Re: Better option to load data to cassandra

2014-11-12 Thread Brice Dutheil
On our project we wrote ourself a custom batch to load the data to cassandra the way we wanted. -- Brice On Tue, Nov 11, 2014 at 2:33 PM, srinivas rao wrote: > hi Alexey, > > i tried with sqoop, and data stax copy command. any other options we can > use. > > i have one more question that, have

Re: Better option to load data to cassandra

2014-11-11 Thread srinivas rao
hi Alexey, i tried with sqoop, and data stax copy command. any other options we can use. i have one more question that, have a table with compisite key as row key, so how can i do using sqoop or copy command while exporing. Thanks Srinivas On Tue, Nov 11, 2014 at 6:28 PM, Plotnik, Alexey wrot

Re: Better option to load data to cassandra

2014-11-11 Thread Plotnik, Alexey
What have you tried? -- Original Message -- From: "srinivas rao" mailto:pinnakasrin...@gmail.com>> To: "Cassandra Users" mailto:user@cassandra.apache.org>> Sent: 11.11.2014 22:51:54 Subject: Better option to load data to cassandra Hi Team, Please suggest me the better options to load da