I have a table defined in cql like this:
CREATE TABLE chatmessages (
PRIMARY KEY (username, spotname, id)
That I insert messages into. Occasionally "rows" are deleted. My question is why, when I query for a "row" using a select query specific to only that "row" which contains cells that have never been deleted such as:
select * from chatmessages where username='adam' and spotname='adam:cherie' and id =1860;
Am I seeing in the cqlsh trace that 1 tombstoned cell has been read:
"Read 1 live and 1 tombstoned cells"
Thanks for any way you can help increase my understanding of what's going on here.