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 pavlikus@gmail.com designates
 209.85.212.179 as permitted sender)
MIME-Version: 1.0
From: "pavlikus@gmail.com" <pavlikus@gmail.com>
Date: Thu, 7 Nov 2013 14:05:44 +0200
Message-ID: 
 <CADUhnxRvdtL_ChT8Onjxa8W6fu5d_f=ZtECuA35uak1U4kqz_A@mail.gmail.com>
Subject: Cannot restrict PRIMARY KEY part bucket_id by IN relation as a
 collection is selected by the query
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=047d7b5d971b0ff96704ea9517c6

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

Hey guys, just started to learn Cassandra recently, got a simple
(hopefully) question on querying.

There's a table with composite primary key - mdid and bucket_id. So I
assume mdid is going to be a partition key and bucket_id is a clustering
key. There're also two more columns to hold a text and a map. See
http://pastie.org/private/fcygmm891hgg4ugyjhtjg for a full picture.

So, I am basically going to have a big row with may buckets. In my
application I am going to retrieve a subset of buckets, not all of them at
once, so I do this:

select .... where mdid='1' and bucket_id in ('global_props', 'test_bucket')


But that gives the error in the subject.

There's pretty interesting thing is that if I query for text column then
the query works, while does not work for the map column. Check the two
queries at the bottom http://pastie.org/private/fcygmm891hgg4ugyjhtjgplease.

Should this be modelled in a different way in Cassandra? Could you please
advice?

Thanks,
Pavlo

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

<div dir=3D"ltr">Hey guys, just started to learn Cassandra recently, got a =
simple (hopefully) question on querying.<div><br></div><div>There&#39;s a t=
able with composite primary key - mdid and bucket_id. So I assume mdid is g=
oing to be a partition key and bucket_id is a clustering key. There&#39;re =
also two more columns to hold a text and a map. See <a href=3D"http://pasti=
e.org/private/fcygmm891hgg4ugyjhtjg">http://pastie.org/private/fcygmm891hgg=
4ugyjhtjg</a> for a full picture.</div>

<div><br></div><div>So, I am basically going to have a big row with may buc=
kets. In my application I am going to retrieve a subset of buckets, not all=
 of them at once, so I do this:</div><div><br></div><blockquote class=3D"gm=
ail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left-width:1px;border-l=
eft-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">

select .... where mdid=3D&#39;1&#39; and bucket_id in (&#39;global_props=
9;, &#39;test_bucket&#39;)</blockquote><div><br></div><div>But that gives t=
he error in the subject.</div><div><br></div><div>There&#39;s pretty intere=
sting thing is that if I query for text column then the query works, while =
does not work for the map column. Check the two queries at the bottom <a hr=
ef=3D"http://pastie.org/private/fcygmm891hgg4ugyjhtjg">http://pastie.org/pr=
ivate/fcygmm891hgg4ugyjhtjg</a> please.</div>

<div><br></div><div>Should this be modelled in a different way in Cassandra=
? Could you please advice?</div><div><br></div><div>Thanks,=A0</div><div>Pa=
vlo</div></div>

--047d7b5d971b0ff96704ea9517c6--