incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Edward Capriolo <edlinuxg...@gmail.com>
Subject Re: Anyway To Query Just The Partition Key?
Date Sat, 13 Apr 2013 11:26:21 GMT
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