Hi, 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? Thanks, -Ravi
