cassandra - How to do multiget in CQL3 for composite row key? -

cassandra - How to do multiget in CQL3 for composite row key? -

cf schema:

create table mytable ( upperid int, lowerid int, hr timestamp, counter text, succ int, fail int, primary key ((upperid, lowerid), hour, counter));

each record keyed composite id upperid:lowerid, how can multiget cql3?

this not valid:

select * mytable (upperid, lowerid) in ((10000, 1), (10000, 2), (20000, 1));

i can't either:

select * mytable (upperid = 10000 , lowerid in (1, 2)) or (upperid = 20000 , lowerid = 1);

i got error: missing eof @ ')'.

please help point effective way multiget composite row key in cql3.

thanks, william

cql not yet back upwards logical "or" in select statements.

instead, in application combine result sets 2 queries:

select * mytable upperid = 10000 , lowerid in (1, 2); select * mytable upperid = 20000 , lowerid = 1;

reference:

so question: alternative or status after clause in select statement cassandra latest cql docs

cassandra cql3