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 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
