We would like to create a Cassandra table with Simple Primary Key that is consisted of UUID column.
The table will look like:
CREATE TABLE simple_table(
id UUID PRIMARY KEY,
col1 text,
col2 text,
col3 UUID
);
This table will potentially store few billions of rows, and the rows should expire after some time (few months) using the TTL feature. I have few questions regarding the efficiency of this table:
After reading the blog (and the comments) that @Alex referred me to, I concluded that tombstones are created for expired rows due to default_time_to_live
of the table.
Those tombstones will be cleaned only after gc_grace_periods
have passed. See this stack overflow question.
Regarding my first questions this datastax page describes it pretty well.