incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gareth Collins <gareth.o.coll...@gmail.com>
Subject Re: Anyway To Query Just The Partition Key?
Date Sat, 13 Apr 2013 18:16:49 GMT
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 <edlinuxguru@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.collins@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
>>
>
>

Mime
View raw message