Hector (Cassandra) Delete Anomaly

Question

Using hector (cassandra client) when I try to do delete, it deletes the columns…but leaves the row key behind…does anyone know why, and how can I delete that row key as well ?

Found the answer on Cassandra chat --> http://wiki.apache.org/cassandra/FAQ#range_ghosts — Ankush, Sep 07 '11 at 23:03

score 3 · Accepted Answer · answered Sep 08 '11 at 05:04

This is expected when using Cassandra. Since it deletes by writing tombstones the data is still there until the next compaction. Eventually it will go a way completely, but your application code must be aware that an empty row is the same as a deleted row.

score 1 · Answer 2 · edited Oct 02 '12 at 12:47

1

Actually, it will go away in the next compaction that happens after the grace period for that row.

Check this out: Wikipedia

edited Oct 02 '12 at 12:47

Eduardo

551
6
15

answered Sep 20 '11 at 16:39

Patricio

919
1
6
8

Hector (Cassandra) Delete Anomaly

2 Answers2

Linked