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:07:24 GMT
Thank you for the answer.

My apologies. I should have been clearer with my question.

Say for example, I have a 1000 partition keys and 10000 rows per partition
key I am trying to avoid bringing back 10 million rows to find the 1000
partition keys. I assume I cannot avoid bringing back the 10 million rows
(or at least an order of magnitude more than 1000 rows) without having
another table?

thanks,
Gareth


On Sat, Apr 13, 2013 at 4:13 AM, Jabbar Azam <ajazam@gmail.com> wrote:

> 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