incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gareth Collins <>
Subject Re: Anyway To Query Just The Partition Key?
Date Sat, 13 Apr 2013 18:16:49 GMT

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

thanks again,

On Sat, Apr 13, 2013 at 7:26 AM, Edward Capriolo <>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 <
>> 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

View raw message