I researched and tried to understand "DELETE" operator recently.I already almost understand.
I still have one question about it because I don't know the deep internals of Cassandra.
Question: What happens if I delete not existing data?
AFAIK, "DELETE" operator is going to write something data.
I am not sure, will I get a big sstable after "nodetool flush" or not?
table info: CREATE TABLE data_t ( id bigint PRIMARY KEY, name text )
This table is empty now.
If I delete not existing data in loop.
Like this: for DELETE FROM data_t WHERE id = $1; done
So many DML in Cassandra(continuously):
DELETE FROM data_t WHERE id = 1; DELETE FROM data_t WHERE id = 2; DELETE FROM data_t WHERE id = 3; ...etc
End of Example.