You are right, only new inserts after delete are taken into account:

CREATE KEYSPACE ks WITH replication = {'class': 'SimpleStrategy', 
'replication_factor': 1};

CREATE TABLE ks.tb (id int PRIMARY KEY , str text);

INSERT INTO ks.tb (id, str) VALUES ( 0,'qqqq');

DELETE from ks.tb WHERE id =0;

INSERT INTO ks.tb (id) VALUES ( 0);

SELECT * FROM ks.tb ;



 id | str

----+------

  0 | null



(1 rows)




Best regards, Vladimir Yudovin, 

Winguzone - Cloud Cassandra Hosting






---- On Wed, 23 Nov 2016 11:59:51 -0500Andrew Cooper 
<andrew.coo...@nisc.coop> wrote ----




What would be returned in the following example?

 

Row with columns exists

Row is deleted (row tombstone)

Row key is recreated

 

Would columns that existed before the row delete/tombstone show back up in a 
read if the row key is recreated?

My assumption is that the row key tombstone timestamp is taken into 
consideration on the read path and all columns with timestamp less than key 
tombstone are ignored in the response.

I have not dug into the codebase yet.  If anyone can shed light on this 
question from their own experiences that would be helpful.

 

Thanks,

 

-Andrew







Reply via email to