What you want is https://issues.apache.org/jira/browse/CASSANDRA-4536 I believe.
On Sat, Apr 13, 2013 at 8:16 PM, Gareth Collins <gareth.o.coll...@gmail.com>wrote: > Edward, > > Thanks for the response. This is what I thought. The only reason why I am > doing it like this is that I don't know these partition keys in advance > (otherwise I would design this differently). So when I need to insert data, > it looks like I need to insert to both the data table and the table > containing the partition keys. Good thing writes in Cassandra are > idempotent...:) > > thanks again, > Gareth > > > On Sat, Apr 13, 2013 at 7:26 AM, Edward Capriolo <edlinuxg...@gmail.com>wrote: > >> You can 'list' or 'select *' the column family and you get them in a >> pseudo random order. When you say subset it implies you might want a >> specific range which is something this schema can not do. >> >> >> >> >> On Sat, Apr 13, 2013 at 2:05 AM, Gareth Collins < >> gareth.o.coll...@gmail.com> wrote: >> >>> Hello, >>> >>> If I have a cql3 table like this (I don't have a table with this data - >>> this is just for example): >>> >>> create table ( >>> surname text, >>> city text, >>> country text, >>> event_id timeuuid, >>> data text, >>> PRIMARY KEY ((surname, city, country),event_id)); >>> >>> there is no way of (easily) getting the set (or a subset) of partition >>> keys, is there (i.e. surname/city/country)? If I want easy access to do >>> queries to get a subset of the partition keys, I have to create another >>> table? >>> >>> I am assuming yes but just making sure I am not missing something >>> obvious here. >>> >>> thanks in advance, >>> Gareth >>> >> >> >