Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: neutral (athena.apache.org: local policy)
MIME-Version: 1.0
From: Maxim Veksler <maxim@vekslers.org>
Date: Mon, 5 Nov 2012 11:53:41 +0200
Message-ID: 
 <CAEAMzo3XO3FoBMRSXOAx4e3Q4RPj7UY3v5ZKCzLXEi2Bz3Zi6Q@mail.gmail.com>
Subject: Creating index on part of composite key with Cassandra 1.2.0-beta1
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=bcaec54ee8a40ee14404cdbc77d0

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

Hi,

I'm attempting to build an index on a column acting as part of a composite
key.

This is what I have so far:

CREATE TABLE userinfo2 (
       campaignId int,
       TS timestamp,
       somevalue text,
       PRIMARY KEY (campaignId, TS)
   );


INSERT INTO userinfo2 (campaignId, TS, somevalue) VALUES (23, '2012-10-01',
'Fuck that');
INSERT INTO userinfo2 (campaignId, TS, somevalue) VALUES (52, '2012-10-01',
'Fuck that too');


cqlsh:test1> CREATE INDEX campaignIdIndex ON userinfo2 (campaignId);
*Bad Request: Cannot create index on PRIMARY KEY part campaignid*
*Perhaps you meant to use CQL 2? Try using the -2 option when starting
cqlsh.*


Building an index on other columns works,
cqlsh:test1> CREATE INDEX campaignIdIndex ON userinfo2 (somevalue);


Am I doing something wrong? Are indexes on composite column supported ? If
not, a suggestion for a work around?


Thank you,
Maxim.

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

<div dir=3D"ltr">Hi,<div><br></div><div>I&#39;m attempting to build an inde=
x on a column acting as part of a composite key.</div><div><br></div><div>T=
his is what I have so far:</div><div><br></div><div><div>CREATE TABLE useri=
nfo2 (</div>

<div>=A0 =A0 =A0 =A0campaignId int,</div><div>=A0 =A0 =A0 =A0TS timestamp,<=
/div><div>=A0 =A0 =A0 =A0somevalue text,</div><div>=A0 =A0 =A0 =A0PRIMARY K=
EY (campaignId, TS)</div><div>=A0 =A0);</div></div><div><br></div><div><br>=
</div><div><div>INSERT INTO userinfo2 (campaignId, TS, somevalue) VALUES (2=
3, &#39;2012-10-01&#39;, &#39;Fuck that&#39;);</div>

<div>INSERT INTO userinfo2 (campaignId, TS, somevalue) VALUES (52, &#39;201=
2-10-01&#39;, &#39;Fuck that too&#39;);</div><div><br></div><div><br></div>=
<div><div>cqlsh:test1&gt; CREATE INDEX campaignIdIndex ON userinfo2 (campai=
gnId);</div>

<div><b>Bad Request: Cannot create index on PRIMARY KEY part campaignid</b>=
</div><div><b>Perhaps you meant to use CQL 2? Try using the -2 option when =
starting cqlsh.</b></div></div></div><div><br></div><div><br></div><div>

Building an index on other columns works,=A0</div><div><div>cqlsh:test1&gt;=
 CREATE INDEX campaignIdIndex ON userinfo2 (somevalue);</div></div><div><br=
></div><div><br></div><div><br></div><div>Am I doing something wrong? Are i=
ndexes on composite column supported ? If not, a suggestion for a work arou=
nd?</div>

<div><br></div><div><br></div><div>Thank you,</div><div>Maxim.</div></div>

--bcaec54ee8a40ee14404cdbc77d0--