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

[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  wrote:

> 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 | Linkedin: *linkedin.com/in/carlosjuzarterolo
> *
> Tel: 1649
> www.pythian.com
>
> On Fri, Feb 6, 2015 at 12:21 PM, diwayou  wrote:
>
>> 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
>>
>
>
> --
>
>
>
>


-- 
Jens Rantil
Backend engineer
Tink AB

Email: jens.ran...@tink.se
Phone: +46 708 84 18 32
Web: www.tink.se

Facebook  Linkedin

 Twitter 

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

[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 | Linkedin: *linkedin.com/in/carlosjuzarterolo
*
Tel: 1649
www.pythian.com

On Fri, Feb 6, 2015 at 12:21 PM, diwayou  wrote:

> 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
>

-- 


--

how to batch the select query to reduce network communication

[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