Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (nike.apache.org: domain of me@carllerche.com designates
 209.85.216.171 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAL-fFJfxmfYYW5Z+2CuLLRUzY4ujD6e5VtjgzwW-B1-e3+ahGg@mail.gmail.com>
References: 
 <CAL-fFJfxmfYYW5Z+2CuLLRUzY4ujD6e5VtjgzwW-B1-e3+ahGg@mail.gmail.com>
Date: Wed, 4 Sep 2013 10:33:53 -0700
Message-ID: 
 <CAL-fFJejRLWO4TS8wi4Qbfu4EQY_BhBjCE2M9crfazS6g-v+Yw@mail.gmail.com>
Subject: Re: Selecting multiple rows with composite partition keys using CQL3
From: Carl Lerche <me@carllerche.com>
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=001a11c2ba708d392e04e59235b6

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

I can't find a way to do this with the current implementation of CQL3. Are
there any plans to add an OR feature to CQL3 or some other way to select a
batch of disjoint composite keys?


On Fri, Aug 30, 2013 at 7:52 PM, Carl Lerche <me@carllerche.com> wrote:

> Hello,
>
> I've been trying to figure out how to port my application to CQL3 based on
> http://cassandra.apache.org/doc/cql3/CQL.html.
>
> I have a table with a primary key: ( (app, name), timestamp ). So, the
> partition key would be composite (on app and name). I'm trying to figure
> out if there is a way to select multiple rows that span partition keys.
> Basically, I am trying to do:
>
> SELECT .. WHERE (app = 'foo' AND name = 'bar' AND timestamp = 123) OR (app
> = 'foo' AND name='hello' AND timestamp = 123)
>

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

<div dir=3D"ltr">I can&#39;t find a way to do this with the current impleme=
ntation of CQL3. Are there any plans to add an OR feature to CQL3 or some o=
ther way to select a batch of disjoint composite keys?</div><div class=3D"g=
mail_extra">
<br><br><div class=3D"gmail_quote">On Fri, Aug 30, 2013 at 7:52 PM, Carl Le=
rche <span dir=3D"ltr">&lt;<a href=3D"mailto:me@carllerche.com" target=3D"_=
blank">me@carllerche.com</a>&gt;</span> wrote:<br><blockquote class=3D"gmai=
l_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left=
:1ex">
<div dir=3D"ltr">Hello,<div><br></div><div>I&#39;ve been trying to figure o=
ut how to port my application to CQL3 based on=A0<a href=3D"http://cassandr=
a.apache.org/doc/cql3/CQL.html" target=3D"_blank">http://cassandra.apache.o=
rg/doc/cql3/CQL.html</a>.</div>

<div><br></div><div>I have a table with a primary key: ( (app, name), times=
tamp ). So, the partition key would be composite (on app and name). I&#39;m=
 trying to figure out if there is a way to select multiple rows that span p=
artition keys. Basically, I am trying to do:</div>

<div><br></div><div>SELECT .. WHERE (app =3D &#39;foo&#39; AND name =3D =
9;bar&#39; AND timestamp =3D 123) OR (app =3D &#39;foo&#39; AND name=3D&#39=
;hello&#39; AND timestamp =3D 123)</div></div>
</blockquote></div><br></div>

--001a11c2ba708d392e04e59235b6--