Re: CQL query regarding indexes

2014-06-13 Thread Akash Pandey
Use senttime as part of primary key CREATE TABLE services.messagepayload_by_date ( record_date timestamp partition_id uuid, messageid bigint, senttime timestamp, PRIMARY KEY (record_date, senttime ) ) Partition id itself should be chronological say a date. Then you put partition id in yo

Re: CQL query regarding indexes

2014-06-12 Thread Jabbar Azam
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. > > Th

Re: CQL query regarding indexes

2014-06-12 Thread Bulat Shakirzyanov
xed > 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-i

CQL query regarding indexes

2014-06-12 Thread Roshan
-- 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-u...@incubator.apache.org mailing list archive at Nabble.com.