incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Petter von Dolwitz (Hem)" <petter.von.dolw...@gmail.com>
Subject Re: Cannot get secondary indexes on fields in compound primary key to work (Cassandra 2.0.0)
Date Sun, 08 Sep 2013 07:44:54 GMT
Thank you for you reply.

I will look into this. I cannot not get my head around why the scenario I
am describing does not work though. Should I report an issue around this or
is this expected behaviour? A similar setup is described on this blog post
by the development lead.

http://www.datastax.com/dev/blog/cql3-for-cassandra-experts




2013/9/6 Robert Coli <rcoli@eventbrite.com>

> 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