What version of Cassandra are you running? Are you by any chance running repairs on your data?
On Mon, Mar 30, 2015 at 5:39 PM, Benyi Wang <bewang.t...@gmail.com> wrote: > Thanks for replying. > > In cqlsh, if I change to Quorum (Consistency quorum), sometime the select > return the deleted row, sometime not. > > I have two virtual data centers: service (3 nodes) and analytics(4 nodes > collocate with Hadoop data nodes).The table has 3 replicas in service and 2 > in analytics. When I wrote, I wrote into analytics using local_one. So I > guest the data may not replicated to all nodes yet. > > I will try to use strong consistency for write. > > > > On Mon, Mar 30, 2015 at 11:59 AM, Prem Yadav <ipremya...@gmail.com> wrote: > >> Increase the read CL to quorum and you should get correct results. >> How many nodes do you have in the cluster and what is the replication >> factor for the keyspace? >> >> On Mon, Mar 30, 2015 at 7:41 PM, Benyi Wang <bewang.t...@gmail.com> >> wrote: >> >>> Create table tomb_test ( >>> guid text, >>> content text, >>> range text, >>> rank int, >>> id text, >>> cnt int >>> primary key (guid, content, range, rank) >>> ) >>> >>> Sometime I delete the rows using cassandra java driver using this query >>> >>> DELETE FROM tomb_test WHERE guid=? and content=? and range=? >>> >>> in Batch statement with UNLOGGED. CONSISTENCE_LEVEL is local_one. >>> >>> But if I run >>> >>> SELECT * FROM tomb_test WHERE guid='guid-1' and content='content-1' and >>> range='week' >>> or >>> SELECT * FROM tomb_test WHERE guid='guid-1' and content='content-1' and >>> range='week' and rank = 1 >>> >>> The result shows the deleted rows. >>> >>> If I run this select, the deleted rows are not shown >>> >>> SELECT * FROM tomb_test WHERE guid='guid-1' and content='content-1' >>> >>> If I run delete statement in cqlsh, the deleted rows won't show up. >>> >>> How can I fix this? >>> >>> >> > -- *Paulo Motta* Chaordic | *Platform* *www.chaordic.com.br <http://www.chaordic.com.br/>* +55 48 3232.3200
