incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sylvain Lebresne <sylv...@datastax.com>
Subject Re: Anyway To Query Just The Partition Key?
Date Mon, 22 Apr 2013 11:29:34 GMT
What you want is https://issues.apache.org/jira/browse/CASSANDRA-4536 I
believe.


On Sat, Apr 13, 2013 at 8:16 PM, Gareth Collins
<gareth.o.collins@gmail.com>wrote:

> 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