how to batch the select query to reduce network communication

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

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

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

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