You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Joshua Partogi <jo...@gmail.com> on 2011/02/11 11:33:36 UTC

Why is it when I removed a row the RowKey is still there?

Hi,

I am very puzzled with this. So I removed a row from the client, but
when I query the data from CLI, the rowkey is still there:
RowKey: 3
-------------------
RowKey: 2
=> (column=6e616d65, value=42696c6c, timestamp=1297338131027004)
-------------------
RowKey: 1
=> (column=6e616d65, value=4a6f65, timestamp=1297420269035522)


Did I do something wrong? What do I need to do in order to completely
remove the entire row with its key.

Thank you for the assistance.

Kind regards,
Joshua

-- 
http://twitter.com/jpartogi

AW: Why is it when I removed a row the RowKey is still there?

Posted by Roland Gude <ro...@yoochoose.com>.
It has something to do with the way data is deleted in Cassandra. You are not doing anything wrong.
See here http://wiki.apache.org/cassandra/FAQ#range_ghosts
Or here: http://wiki.apache.org/cassandra/DistributedDeletes
For some more detail


-----Ursprüngliche Nachricht-----
Von: Joshua Partogi [mailto:joshua.java@gmail.com] 
Gesendet: Freitag, 11. Februar 2011 11:34
An: user@cassandra.apache.org
Betreff: Why is it when I removed a row the RowKey is still there?

Hi,

I am very puzzled with this. So I removed a row from the client, but
when I query the data from CLI, the rowkey is still there:
RowKey: 3
-------------------
RowKey: 2
=> (column=6e616d65, value=42696c6c, timestamp=1297338131027004)
-------------------
RowKey: 1
=> (column=6e616d65, value=4a6f65, timestamp=1297420269035522)


Did I do something wrong? What do I need to do in order to completely
remove the entire row with its key.

Thank you for the assistance.

Kind regards,
Joshua

-- 
http://twitter.com/jpartogi