Return-Path: 
 <user-return-33404-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org>
X-Original-To: apmail-cassandra-user-archive@www.apache.org
Delivered-To: apmail-cassandra-user-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id 1D39AF0C9
	for <apmail-cassandra-user-archive@www.apache.org>;
 Sat, 13 Apr 2013 06:06:09 +0000 (UTC)
Received: (qmail 96825 invoked by uid 500); 13 Apr 2013 06:06:06 -0000
Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org
Received: (qmail 96699 invoked by uid 500); 13 Apr 2013 06:06:06 -0000
Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@cassandra.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@cassandra.apache.org>
List-Post: <mailto:user@cassandra.apache.org>
List-Id: <user.cassandra.apache.org>
Reply-To: user@cassandra.apache.org
Delivered-To: mailing list user@cassandra.apache.org
Received: (qmail 96671 invoked by uid 99); 13 Apr 2013 06:06:05 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 13 Apr 2013 06:06:05 +0000
X-ASF-Spam-Status: No, hits=2.5 required=5.0
	tests=FILL_THIS_FORM_SHORT,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of gareth.o.collins@gmail.com
 designates 209.85.217.180 as permitted sender)
Received: from [209.85.217.180] (HELO mail-lb0-f180.google.com)
 (209.85.217.180)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 13 Apr 2013 06:05:58 +0000
Received: by mail-lb0-f180.google.com with SMTP id t11so3219781lbi.39
        for <user@cassandra.apache.org>; Fri, 12 Apr 2013 23:05:37 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20120113;
        h=mime-version:x-received:date:message-id:subject:from:to
         :content-type;
        bh=TdoZBVRtQd/1lKlHRjsqbFdWzKqjznSoCOskTaqqTT8=;
        b=id0YCgYyaiU/7RA9paBm/IYPAZU8BwNyh0asH5eh6CAoHDZmOKEewqUWGqJjStHE2B
         LVhkYS7kvhIx5rusfdfRZgzuVRFJXy3ElSQ53HfQX+1gvFniX8zJHASJ2RVC2XEwk7G9
         fZ29cl4poKhuOJhUU7CUif+yk4ioBWbSBaEcbEQOqK/9LyqZPyLqVfGtMYWLJv9/4wtK
         OLU130Ne6KhIk/wOEfIZ3PucFDwI8b3ie8EF63/e5Xyoqnk4H3PlY4sF691BUjZ2O4Wr
         MYgbVRV6YbMsb47T1jIdlAVxljR30cfTzxfgx8Lx5yvjmxrglo4/1v0hPBF4WkZB2Kvr
         0tiA==
MIME-Version: 1.0
X-Received: by 10.112.130.97 with SMTP id od1mr1974998lbb.3.1365833137389;
 Fri, 12 Apr 2013 23:05:37 -0700 (PDT)
Received: by 10.112.32.100 with HTTP; Fri, 12 Apr 2013 23:05:37 -0700 (PDT)
Date: Sat, 13 Apr 2013 02:05:37 -0400
Message-ID: 
 <CALemSr6wpM9pDNkrqs-FPxnZRk_mvpVcCacA_D=e6=M7nA5WWg@mail.gmail.com>
Subject: Anyway To Query Just The Partition Key?
From: Gareth Collins <gareth.o.collins@gmail.com>
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=047d7b343436fa068604da37ceb6
X-Virus-Checked: Checked by ClamAV on apache.org

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

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

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

<div dir=3D"ltr">Hello,<div><br></div><div style>If I have a cql3 table lik=
e this (I don&#39;t have a table with this data - this is just for example)=
:</div><div style><br></div><div style>create table (</div><div style>=A0 =
=A0 surname text,</div>
<div style>=A0 =A0 city text,</div><div style>=A0 =A0 country text,</div><d=
iv style>=A0 =A0 event_id timeuuid,</div><div style>=A0 =A0 data text,</div=
><div style>=A0 =A0 PRIMARY KEY ((surname, city, country),event_id));</div>=
<div style><br></div>
<div style>there is no way of (easily) getting the set (or a subset) of par=
tition 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?</div>
<div style><br></div><div style>I am assuming yes but just making sure I am=
 not missing something obvious here.</div><div style><br></div><div style>t=
hanks in advance,</div><div style>Gareth</div></div>

--047d7b343436fa068604da37ceb6--