Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: neutral (nike.apache.org: local policy)
MIME-Version: 1.0
Sender: roland.mechler@extjs.com
Date: Fri, 11 May 2012 09:43:49 -0700
Message-ID: 
 <CA+Ht57qVO4kLFuSEhY13hkpdfRvBWCdE9pzZRjYaETYFdZi3Dw@mail.gmail.com>
Subject: Select on indexed columns and with IN clause for the PRIMARY KEY
From: Roland Mechler <rmechler@sencha.com>
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=f46d04389333d8ca1304bfc570a2

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

I am using C* 1.1 and CQL 3.0. Am trying to do a select with an IN clause
for the primary key, and on an indexed column, which appears to not be
supported:

    cqlsh:Keyspace1> SELECT * FROM TestTable WHERE id IN ('1', '2') AND
data = 'b';
    Bad Request: Select on indexed columns and with IN clause for the
PRIMARY KEY are not supported

Any chance this will be supported in the future?


Full example:

cqlsh:Keyspace1> CREATE TABLE TestTable (id text PRIMARY KEY, data text);
cqlsh:Keyspace1> CREATE INDEX ON TestTable (data);
cqlsh:Keyspace1> INSERT INTO TestTable (id, data) VALUES ('1', 'a');
cqlsh:Keyspace1> INSERT INTO TestTable (id, data) VALUES ('2', 'b');
cqlsh:Keyspace1> INSERT INTO TestTable (id, data) VALUES ('3', 'b');
cqlsh:Keyspace1> SELECT * FROM TestTable WHERE id IN ('1', '2');
 id | data
----+------
  1 |    a
  2 |    b

cqlsh:Keyspace1> SELECT * FROM TestTable WHERE data = 'b';
 id | data
----+------
  3 |    b
  2 |    b

cqlsh:Keyspace1> SELECT * FROM TestTable WHERE id IN ('1', '2') AND data =
'b';
Bad Request: Select on indexed columns and with IN clause for the PRIMARY
KEY are not supported
cqlsh:Keyspace1>

-Roland

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

I am using C* 1.1 and CQL 3.0. Am trying to do a select with an IN clause f=
or the primary key, and on an indexed column, which appears to not be suppo=
rted:<div><br></div><div><div>=A0 =A0 cqlsh:Keyspace1&gt; SELECT * FROM Tes=
tTable WHERE id IN (&#39;1&#39;, &#39;2&#39;) AND data =3D &#39;b&#39;;</di=
v>
<div>=A0 =A0 Bad Request: Select on indexed columns and with IN clause for =
the PRIMARY KEY are not supported</div></div><div><br></div><div>Any chance=
 this will be supported in the future?</div><div><br></div><div><br></div><=
div>
Full example:</div><div><br></div><div><div>cqlsh:Keyspace1&gt; CREATE TABL=
E TestTable (id text PRIMARY KEY, data text);</div><div>cqlsh:Keyspace1&gt;=
 CREATE INDEX ON TestTable (data);</div><div>cqlsh:Keyspace1&gt; INSERT INT=
O TestTable (id, data) VALUES (&#39;1&#39;, &#39;a&#39;);</div>
<div>cqlsh:Keyspace1&gt; INSERT INTO TestTable (id, data) VALUES (&#39;2=
9;, &#39;b&#39;);</div><div>cqlsh:Keyspace1&gt; INSERT INTO TestTable (id, =
data) VALUES (&#39;3&#39;, &#39;b&#39;);</div><div>cqlsh:Keyspace1&gt; SELE=
CT * FROM TestTable WHERE id IN (&#39;1&#39;, &#39;2&#39;);</div>
<div>=A0id | data</div><div>----+------</div><div>=A0 1 | =A0 =A0a</div><di=
v>=A0 2 | =A0 =A0b</div><div><br></div><div>cqlsh:Keyspace1&gt; SELECT * FR=
OM TestTable WHERE data =3D &#39;b&#39;;</div><div>=A0id | data</div><div>-=
---+------</div>
<div>=A0 3 | =A0 =A0b</div><div>=A0 2 | =A0 =A0b</div><div><br></div><div>c=
qlsh:Keyspace1&gt; SELECT * FROM TestTable WHERE id IN (&#39;1&#39;, &#39;2=
&#39;) AND data =3D &#39;b&#39;;</div><div>Bad Request: Select on indexed c=
olumns and with IN clause for the PRIMARY KEY are not supported</div>
<div>cqlsh:Keyspace1&gt;=A0</div></div><div><br></div><div>-Roland</div><di=
v><br></div>

--f46d04389333d8ca1304bfc570a2--