Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (athena.apache.org: domain of petter.von.dolwitz@gmail.com
 designates 209.85.220.176 as permitted sender)
MIME-Version: 1.0
Date: Fri, 6 Sep 2013 15:18:19 +0200
Message-ID: 
 <CADFYdErMz1icXGZC3khG6SnOO5X+gviYTPacn87W90T4a9B6Vg@mail.gmail.com>
Subject: Cannot get secondary indexes on fields in compound primary key to
 work (Cassandra 2.0.0)
From: "Petter von Dolwitz (Hem)" <petter.von.dolwitz@gmail.com>
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=bcaec54866724c899504e5b6df28

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

I am struggling with getting secondary indexes to work. I have created
secondary indexes on some fields that are part of the compound primary key
but only one of the indexes seems to work (the one set on the field 'e' on
the table definition below). Using any other secondary index in a where
clause causes the message "Request did not complete within rpc_timeout.".
It seems like if a put a value in the where clause that does not exist in a
column with secondary index then cassandra quickly return with the result
(0 rows) but if a put in a value that do exist I get a timeout. There is no
exception in the logs in connection with this. I've tried to increase the
timeout to a minute but it does not help.

I am currently running on a single machine with 12 GB RAM and the heap set
to 8 GB. The table and indexes occupy 1 GB of disk space. I query the table
with cqlsh.

The below issue should have fixed something in this area. Is this still a
problem or is it something in my environmnet/design that is the problem?
https://issues.apache.org/jira/browse/CASSANDRA-5851

/Petter

----TABLE DEFINITION-----

CREATE TABLE x.y (
  a varchar,
  b varchar,
  c varchar,
  d varchar,
  e varchar,
  f varchar,
  g varchar,
  h varchar,
  i int,
  j varchar,
  k varchar,
  l timestamp,
  m blob,
  PRIMARY KEY (a, b, c, d, e, f, g, h, i, j, k, l)
);

CREATE INDEX d_idx
  ON x.y ( d );

CREATE INDEX e_idx
  ON x.y ( e );

CREATE INDEX f_idx
  ON x.y ( f );

CREATE INDEX g_idx
  ON x.y ( g );

CREATE INDEX h_idx
  ON x.y ( h );

CREATE INDEX i_idx
  ON x.y ( i );

CREATE INDEX j_idx
  ON x.y ( j );

CREATE INDEX k_idx
  ON x.y ( k );

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

<div dir=3D"ltr"><div>I am struggling with getting secondary indexes to wor=
k. I have created secondary indexes on some fields that are part of the com=
pound primary key but only one of the indexes seems to work (the one set on=
 the field &#39;e&#39; on the table definition below). Using any other seco=
ndary index in a where clause causes the message &quot;Request did not comp=
lete within rpc_timeout.&quot;. It seems like if a put a value in the where=
 clause that does not exist in a column with secondary index then cassandra=
 quickly return with the result (0 rows) but if a put in a value that do ex=
ist I get a timeout. There is no exception in the logs in connection with t=
his. I&#39;ve tried to increase the timeout to a minute but it does not hel=
p.<br>
<br></div>I am currently running on a single machine with 12 GB RAM and the=
 heap set to 8 GB. The table and indexes occupy 1 GB of disk space. I query=
 the table with cqlsh.<br><div><br>The below issue should have fixed someth=
ing in this area. Is this still a problem or is it something in my environm=
net/design that is the problem?<br>
<a href=3D"https://issues.apache.org/jira/browse/CASSANDRA-5851">https://is=
sues.apache.org/jira/browse/CASSANDRA-5851</a><br><br></div><div>/Petter<br=
></div><div><br>----TABLE DEFINITION-----<br></div><div><br>CREATE TABLE x.=
y (<br>
=A0 a varchar,<br>=A0 b varchar,<br>=A0 c varchar,<br>=A0 d varchar,<br>=A0=
 e varchar,<br>=A0 f varchar,<br>=A0 g varchar,<br>=A0 h varchar,<br>=A0 i =
int,<br>=A0 j varchar,<br>=A0 k varchar,<br>=A0 l timestamp,<br>=A0 m blob,=
<br>=A0 PRIMARY KEY (a, b, c, d, e, f, g, h, i, j, k, l)<br>
);<br><br>CREATE INDEX d_idx<br>=A0 ON x.y ( d );<br><br>CREATE INDEX e_idx=
<br>=A0 ON x.y ( e );<br><br>CREATE INDEX f_idx<br>=A0 ON x.y ( f );<br><br=
>CREATE INDEX g_idx<br>=A0 ON x.y ( g );<br><br>CREATE INDEX h_idx<br>=A0 O=
N x.y ( h );<br>
<br>CREATE INDEX i_idx<br>=A0 ON x.y ( i );<br><br>CREATE INDEX j_idx<br>=
=A0 ON x.y ( j );<br><br>CREATE INDEX k_idx<br>=A0 ON x.y ( k );<br></div><=
/div>

--bcaec54866724c899504e5b6df28--