Could someone help me on what must be a noddy question pls.
I have a single node cassandra instance running and I'm seeing rows that have been deleted (ie tombstoned) come back when I do a select * statement. Understandably I don't want to be seeing these deleted rows and I thought the tombstone marker /process would prevent these from being returned (until compaction happens). Granted its only the KEY column which comes back on these rows but nevertheless I thought they should be automatically excluded.
Can anyone tell me if this is indeed intended behaviour and if so, what I can do to ignore such tombstoned records in a select * statement pls?
P.S. using :
[cqlsh 2.2.0 | Cassandra 1.1.6-dse-p1 | CQL spec 2.0.0 | Thrift protocol 19.32.0]