incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jabbar Azam <aja...@gmail.com>
Subject Re: Anyway To Query Just The Partition Key?
Date Sat, 13 Apr 2013 08:13:29 GMT
With your example you can do an equality search with surname and city and
then use "in" with country

Eg.  Select * from yourtable where surname="blah" and city="blah blah" and
country in ("country1", "country2")

Hope that helps

Jabbar Azam
On 13 Apr 2013 07:06, "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