cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <>
Subject Re: CQL3 query
Date Wed, 31 Jul 2013 01:57:52 GMT
SlicePredicate only support “N” columns. So, you need to query one facet at a time OR you
can query m columns such that it returns n revisions.  You may need intelligence to increase
or decrease m columns heuristically.

From: ravi prasad
Sent: ‎Tuesday‎, ‎July‎ ‎30‎, ‎2013 ‎8‎:‎11‎ ‎PM
To: cassandramailinglist



I have a data modelling question.  I'm modelling for an use case where, an object can have
multiple facets and each facet can have multiple revisions and the query pattern looks like
"get latest 'n' revisions for all facets for an object (n=1,2,3)".   With a table like below:

create table object (
id uuid,

facet text,

revision timeuuid

value text

primary key (id,facet,revision) #clustered on facet and revision

Does CQL3 support querying efficiently  'get latest revision for all facets where id='something';
 in a single query.   What would the query look like?


View raw message