When I remove rows in Cassandra I delete only columns not row keys

Question

Hi,

If I delete every keys in a ColumnFamily in a Cassandra db using remove(key), then if I use get_range_slices, rows are still there but without columns. How could I remove entire rows?

Thanks Tobia Loschiavo

Answer 1

Why do deleted keys show up during range scans?

Answer 2

Just been having the same issue and I found that:

This has been fixed in 0.7 (https://issues.apache.org/jira/browse/CASSANDRA-1027). And backported to 0.6.3

This is also relevant: https://issues.apache.org/jira/browse/CASSANDRA-494

Answer 3

I tested with cassandra 0.63 and the problem is still the same. I don't think that bug fix is for getting rid of the deleted row ids. See

http://wiki.apache.org/cassandra/FAQ#range_ghosts

for more information.