incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ravi prasad <>
Subject CQL3 query
Date Wed, 31 Jul 2013 00:11:17 GMT
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