Setting the time-to-live (TTL) for value
To set the TTL for data, use the
USING TTL clause.
TTL function may be used to retrieve the TTL information.
USING TTL clause can be used to insert or update data into a table for a specific duration of time.
To determine the current time-to-live for a record, use the
The database storage engine can only encode TTL timestamps through
Insert data into the table
cycling.calendarand use the
USING TTLclause to set the expiration period to 200 seconds.
INSERT INTO cycling.calendar ( race_id, race_name, race_start_date, race_end_date ) VALUES ( 200, 'placeholder', '2015-05-27', '2015-05-27' ) USING TTL 200;
Issue a SELECT statement to determine how much longer the data has to live.
SELECT TTL(race_name) FROM cycling.calendar WHERE race_id = 200;
ttl(race_name) ---------------- 200 (1 rows)
If you repeat this step after some time, the time-to-live value will decrease.
The time-to-live value can also be updated with the
USING TTLclause in an
UPDATE cycling.calendar USING TTL 300 SET race_name = 'Tour de France - Stage 12' WHERE race_id = 200 AND race_start_date = '2015-05-27' AND race_end_date = '2015-05-27';
ttl(race_name) ---------------- 300 (1 rows)