incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Carl Lerche ...@carllerche.com>
Subject Re: Selecting multiple rows with composite partition keys using CQL3
Date Wed, 04 Sep 2013 17:33:53 GMT
I can't find a way to do this with the current implementation of CQL3. Are
there any plans to add an OR feature to CQL3 or some other way to select a
batch of disjoint composite keys?


On Fri, Aug 30, 2013 at 7:52 PM, Carl Lerche <me@carllerche.com> wrote:

> Hello,
>
> I've been trying to figure out how to port my application to CQL3 based on
> http://cassandra.apache.org/doc/cql3/CQL.html.
>
> I have a table with a primary key: ( (app, name), timestamp ). So, the
> partition key would be composite (on app and name). I'm trying to figure
> out if there is a way to select multiple rows that span partition keys.
> Basically, I am trying to do:
>
> SELECT .. WHERE (app = 'foo' AND name = 'bar' AND timestamp = 123) OR (app
> = 'foo' AND name='hello' AND timestamp = 123)
>

Mime
View raw message