I have a table defined in cql like this: CREATE TABLE chatmessages ( username varchar, spotname varchar, id varint, iv varchar, fromuser varchar, fromversion varchar, touser varchar, toversion varchar, datetime timestamp, data varchar, mimetype varchar, datasize int, shareable boolean, 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. Adam