Re: CQL3 delete using < or > ?

2014-02-08 Thread Manoj Khangaonkar
Hi , >From CQL documentation , for the CQL delete statement , the only allowed row specifications are primary_key_name = key_value primary_key_name IN ( *key_value, key_value, ...*) regards On Sat, Feb 8, 2014 at 6:09 PM, Clint Kelly wrote: > Folks, > > Is there any way to perform a delete

CQL3 delete using < or > ?

2014-02-08 Thread Clint Kelly
Folks, Is there any way to perform a delete in CQL of all rows where a particular columns (that is part of the primary key) is less than a certain value? I believe that the corresponding SELECT statement works, as in this example: cqlsh:fiddle> describe table foo; CREATE TABLE foo ( key text,

Re: Buffering for lots of INSERT or UPDATE calls with DataStax Java driver?

2014-02-08 Thread Clint Kelly
Ah yes, thanks! I had forgotten about the use of batches for this purpose. Appreciate the help, cheers! Best regards, Clint On Sat, Feb 8, 2014 at 1:24 PM, DuyHai Doan wrote: > "Is there a recommended way to perform lots of INSERT operations in a row > when using the DataStax Java driver?" --

Re: Buffering for lots of INSERT or UPDATE calls with DataStax Java driver?

2014-02-08 Thread DuyHai Doan
"Is there a recommended way to perform lots of INSERT operations in a row when using the DataStax Java driver?" --> Yes, use UNLOGGED batches. More info here: http://www.datastax.com/documentation/cql/3.0/webhelp/index.html#cql/cql_reference/batch_r.html On Sat, Feb 8, 2014 at 10:19 PM, Clint Ke

Buffering for lots of INSERT or UPDATE calls with DataStax Java driver?

2014-02-08 Thread Clint Kelly
Folks, Is there a recommended way to perform lots of INSERT operations in a row when using the DataStax Java driver? I notice that the RecordWriter for the CQL3 Hadoop implementation in Cassandra does some per-data-node buffering of CQL3 queries. The DataStax Java driver, on the other hand, supp