cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jabbar Azam <aja...@gmail.com>
Subject Re: CQL query regarding indexes
Date Thu, 12 Jun 2014 23:40:43 GMT
In this use case you don't need the secondary index. Instead use Primary
key(partition_id, senttime)

Thanks

Jabbar Azam
On 12 Jun 2014 23:44, "Roshan" <codevally@gmail.com> wrote:

> Hi
>
> Cassandra - 2.0.8
> DataStax driver - 2.0.2
>
> I have create a keyspace and a table with indexes like below.
> CREATE TABLE services.messagepayload (
>   partition_id uuid,
>   messageid bigint,
>   senttime timestamp,
>   PRIMARY KEY (partition_id)
> ) WITH compression =
>     { 'sstable_compression' : 'LZ4Compressor', 'chunk_length_kb' : 64 };
>
> CREATE INDEX idx_messagepayload_senttime ON services.messagepayload
> (senttime);
>
> While I am running the below query I am getting an exception.
>
> SELECT * FROM b_bank_services.messagepayload WHERE senttime>=1401544800000
> AND senttime<=1401717600000 ALLOW FILTERING;
>
> com.datastax.driver.core.exceptions.InvalidQueryException: No indexed
> columns present in by-columns clause with Equal operator
>
> Could someone can explain what's going on? I have create a index to the
> search column, but seems not working.
>
> Thanks.
>
>
>
> --
> View this message in context:
> http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/CQL-query-regarding-indexes-tp7595122.html
> Sent from the cassandra-user@incubator.apache.org mailing list archive at
> Nabble.com.
>

Mime
View raw message