Hi Rakesh,
Default consistency level of client is set to 1, from your query it seems you are using CQL so could you try same query by setting CONSISTENCY ALL when you enter cqlsh. Regards Amit Singh From: Rakesh Kumar [mailto:dcrunch...@aim.com] Sent: Wednesday, March 02, 2016 3:25 AM To: user@cassandra.apache.org Subject: Re: Querying on index At this time no one else is using this table. So the data is static. -----Original Message----- From: Rakesh Kumar To: user Sent: Tue, Mar 1, 2016 4:54 pm Subject: Querying on index Cassandra: 3.3On my test system I create a tablecreate table eventinput( event_id varchar , event_class_cd int , event_ts timestamp , client_id varchar , event_message text , primary key ((client_id,event_id),event_ts)) I created an index on client_id create index idx1 on eventinput(client_id);When I query select *from eventinputwhere client_id = 'aa' ALLOW filtering ;I get random results. One time it is 200, another time 400 or 500 or 600 and sometimes 0.Why ?
