Re: Regarding SSTableSplit Utility

2015-02-06 Thread Robert Coli
On Fri, Feb 6, 2015 at 1:15 AM, Parth Setya setya.pa...@gmail.com wrote: SSTable split gives the following error *Exception in thread main java.lang.OutOfMemoryError: GC overhead limit exceede d * How much heap is available to the JVM sstablesplit is running in? Increase it. *Cassandra

Re: Mutable primary key in a table

2015-02-06 Thread Ajaya Agrawal
On Fri, Feb 6, 2015 at 7:43 PM, Adil adil.cha...@gmail.com wrote: Hi, it seems you are doing some thing wrong in your model, why can you go with updating columns of key1 instead of deleting/inserting row key? You can't update a primary key column with update statements.

Regarding SSTableSplit Utility

2015-02-06 Thread Parth Setya
Hello people SSTable split gives the following error *Exception in thread main java.lang.OutOfMemoryError: GC overhead limit exceede d at com.googlecode.concurrentlinkedhashmap.ConcurrentLinkedHashMap.drainB uffers(ConcurrentLinkedHashMap.java:434)

Re: Writing the same column frequently - anti pattern?

2015-02-06 Thread Jens Rantil
Hi, If the writes are coming from the same machine, you could potentially use request collapsing https://github.com/Netflix/Hystrix/wiki/How-To-Use#request-collapsing to avoid the duplicate writes. Just an idea, Jens On Fri, Feb 6, 2015 at 1:15 AM, Andreas Finke andreas.fi...@solvians.com

how to batch the select query to reduce network communication

2015-02-06 Thread diwayou
create table t { a int, b int, c int } if i want to execute select * from t where a = 1 and b = 2 limit 10; select * from t where a = 1 and b = 3 limit 10; how can i batch this, and only execute once to get the result

Mutable primary key in a table

2015-02-06 Thread Ajaya Agrawal
Hi guys, I want to take a row with primary key K1, rewrite it with primary key K2, and delete the original data with key K1, atomically. It seems like the only solution which won't have race conditions is to use batch statement to delete the old row and insert the new one. But the documentation

Re: Mutable primary key in a table

2015-02-06 Thread Adil
Hi, it seems you are doing some thing wrong in your model, why can you go with updating columns of key1 instead of deleting/inserting row key? 2015-02-06 15:02 GMT+01:00 Ajaya Agrawal ajku@gmail.com: Hi guys, I want to take a row with primary key K1, rewrite it with primary key K2, and

Re: how to batch the select query to reduce network communication

2015-02-06 Thread Carlos Rolo
Hi, You can't. Batches are only available for INSERT, UPDATE and DELETE operations. Batches exist to give Cassandra some atomicity, as in, or all operations succeed or all fail. Regards, Regards, Carlos Juzarte Rolo Cassandra Consultant Pythian - Love your data rolo@pythian | Twitter: cjrolo

Re: how to batch the select query to reduce network communication

2015-02-06 Thread Jens Rantil
As an alternative, you could always execute the async to Cassandra and then iterate over the results as they come in. Cheers, Jens On Fri, Feb 6, 2015 at 12:39 PM, Carlos Rolo r...@pythian.com wrote: Hi, You can't. Batches are only available for INSERT, UPDATE and DELETE operations. Batches