Database Reference
In-Depth Information
(1 rows)
cqlsh:mastering_cassandra> SELECT ttl(expirable_col),
ttl(column2) FROM demo_ttl WHERE id = 2;
ttl(expirable_col) | ttl(column2)
--------------------+--------------
2 | 2
(1 rows)
# The row is deleted
cqlsh:mastering_cassandra> SELECT ttl(expirable_col),
ttl(column2) FROM demo_ttl WHERE id = 2;
(0 rows)
# No row, no TTL, obviously
cqlsh:mastering_cassandra> SELECT ttl(expirable_col),
ttl(column2) FROM demo_ttl;
ttl(expirable_col) | ttl(column2)
--------------------+--------------
null | null
(1 rows)
# The TTL is not carried forward to new values on the same
row that had a TTL previously
cqlsh:mastering_cassandra> INSERT INTO demo_ttl (id,
expirable_col, column2) VALUES (2, 'single_cell_TTL', 30);
cqlsh:mastering_cassandra> SELECT ttl(expirable_col),
ttl(column2) FROM demo_ttl WHERE id = 2;
ttl(expirable_col) | ttl(column2)
--------------------+--------------
null | null
