Insert multiple rows in Cassandra

[amit tewari]

Hi, how can I insert multiple rows (say 10K rows) into Cassandra using the nodejs driver?

I have found some articles which talk about Prepared Statements etc., but they seem to be for Java

Thanks

AT

[Alex Popescu]

Hi Amit, 

Besides minor API differences, all the DataStax drivers for Cassandra provide the same features and behave the same so you

can use the best documentation and just translate it to the API of the driver you are using. A couple of resources that could be

helpful to getting you started:

1. https://groups.google.com/a/lists.datastax.com/forum/#!searchin/nodejs-driver-user/insert/nodejs-driver-user/p0cvvih8bwo/vYgAww_uj3gJ

2. http://docs.datastax.com/en/developer/nodejs-driver/2.1/nodejs-driver/reference/parameterizedQueries.html

3. http://docs.datastax.com/en/developer/nodejs-driver/2.1/nodejs-driver/reference/nodejs2Cql3Datatypes.html

-- 

Bests,

Alex Popescu | @al3xandru

Sen. Product Manager @ DataStax

[Gaurav Gupta]

Hi Amit,

You can create 10K queries using either prepared statement or raw statement. After construction of query, execute them in a batch.

CassandraDriverObject.batch(arg1, arg2, cb) is the function for you.
This function takes following arguments:

1. arg1 = An array of object.
   

       Object structure: {query: 'select * from mytable where column1=?', params: ['value1']}

2. arg2 = An object with structure {hints: allQueryHints};
1. allQueryhints is an array of hints for each query. A hint for single query looks like: ['varchar']. Hence allQueryhints will look like: [['varchar']]
   

To unsubscribe from this group and stop receiving emails from it, send an email to nodejs-driver-u...@lists.datastax.com.

-- 
Best regards,

Gaurav Gupta

TERMS OF USE:
The contents of this email are confidential to the intended recipient at the email address to which it has been addressed.  It may not be disclosed to or used by anyone other than this addressee, nor may it be copied in any way. If received in error, please contact Impressico Business Solutions, on +91-120-419-0000 quoting the name of the sender and the addressee and then delete it from your system. Please note that neither Impressico Business Solutions, nor the sender accepts any responsibility for viruses and it is your responsibility to scan the email and attachments (if any).

[Alex Popescu]

On Monday, July 20, 2015 at 11:45:33 PM UTC-7, Gaurav Gupta wrote:

Hi Amit,

You can create 10K queries using either prepared statement or raw statement. After construction of query, execute them in a batch.

Without knowing all the details of what Amit's requirements are, I'd suggest staying away from using Batch. This post explains the pros & cons of using batches and the alternative solutions:

https://lostechies.com/ryansvihla/2014/08/28/cassandra-batch-loading-without-the-batch-keyword/