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)