incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Robert Coli <rc...@eventbrite.com>
Subject Re: Cannot get secondary indexes on fields in compound primary key to work (Cassandra 2.0.0)
Date Fri, 06 Sep 2013 17:13:07 GMT
On Fri, Sep 6, 2013 at 6:18 AM, Petter von Dolwitz (Hem) <
petter.von.dolwitz@gmail.com> wrote:

> 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.
>

In general unless you absolutely need the atomicity of the update of a
secondary index with the underlying storage row, you are better off making
a manual secondary index column family.

=Rob

Mime
View raw message