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

Matroska picture Matroska · Jun 5, 2010 · Viewed 7.1k times · Source

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?

Answer

Schildmeijer picture Schildmeijer · Jun 5, 2010

Why do deleted keys show up during range scans?

Because get_range_slice says, "apply this predicate to the range of rows given," meaning, if the predicate result is empty, we have to include an empty result for that row key. It is perfectly valid to perform such a query returning empty column lists for some or all keys, even if no deletions have been performed.