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