Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (athena.apache.org: domain of edlinuxguru@gmail.com
 designates 209.85.212.177 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CALemSr6wpM9pDNkrqs-FPxnZRk_mvpVcCacA_D=e6=M7nA5WWg@mail.gmail.com>
References: 
 <CALemSr6wpM9pDNkrqs-FPxnZRk_mvpVcCacA_D=e6=M7nA5WWg@mail.gmail.com>
Date: Sat, 13 Apr 2013 07:26:21 -0400
Message-ID: 
 <CAENxBwyZx-eq=nBsmtTezLuZ54vEQcX+a+CvrSXzk_uNzMw3-A@mail.gmail.com>
Subject: Re: Anyway To Query Just The Partition Key?
From: Edward Capriolo <edlinuxguru@gmail.com>
To: "user@cassandra.apache.org" <user@cassandra.apache.org>
Content-Type: multipart/alternative; boundary=f46d0444813100de7e04da3c4aab

--f46d0444813100de7e04da3c4aab
Content-Type: text/plain; charset=ISO-8859-1

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
>

--f46d0444813100de7e04da3c4aab
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">You can &#39;list&#39; or &#39;select *&#39; the column fa=
mily and you get them in a pseudo random order. When you say subset it impl=
ies you might want a specific range which is something this schema can not =
do.<br>
<br><br></div><div class=3D"gmail_extra"><br><br><div class=3D"gmail_quote"=
>On Sat, Apr 13, 2013 at 2:05 AM, Gareth Collins <span dir=3D"ltr">&lt;<a h=
ref=3D"mailto:gareth.o.collins@gmail.com" target=3D"_blank">gareth.o.collin=
s@gmail.com</a>&gt;</span> wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex"><div dir=3D"ltr">Hello,<div><br></div><div>I=
f I have a cql3 table like this (I don&#39;t have a table with this data - =
this is just for example):</div>
<div><br></div><div>create table (</div><div>=A0 =A0 surname text,</div>
<div>=A0 =A0 city text,</div><div>=A0 =A0 country text,</div><div>=A0 =A0 e=
vent_id timeuuid,</div><div>=A0 =A0 data text,</div><div>=A0 =A0 PRIMARY KE=
Y ((surname, city, country),event_id));</div><div><br></div>
<div>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 qu=
eries to get a subset of the partition keys, I have to create another table=
?</div>

<div><br></div><div>I am assuming yes but just making sure I am not missing=
 something obvious here.</div><div><br></div><div>thanks in advance,</div><=
div>Gareth</div></div>
</blockquote></div><br></div>

--f46d0444813100de7e04da3c4aab--