CQL TTL Example

CREATE KEYSPACE mykeyspace WITH replication = {'class': 'SimpleStrategy', 'replication_factor': '1'}  AND durable_writes = true;
USE mykeyspace;
CREATE TABLE heartrate_ttl (
 pet_chip_id  uuid,
 time timestamp,
 heart_rate int,
PRIMARY KEY (pet_chip_id, time))
WITH default_time_to_live = 604800;
ALTER TABLE heartrate_ttl WITH default_time_to_live = 3600;

INSERT INTO heartrate_ttl(pet_chip_id, time, heart_rate) VALUES (123e4567-e89b-12d3-a456-426655440b23, '2019-03-04 07:01:00', 100);
INSERT INTO heartrate_ttl(pet_chip_id, time, heart_rate) VALUES (123e4567-e89b-12d3-a456-426655440b23, '2019-03-04 07:02:00', 103);
INSERT INTO heartrate_ttl(pet_chip_id, time, heart_rate) VALUES (123e4567-e89b-12d3-a456-426655440b23, '2019-03-04 07:03:00', 130);
INSERT INTO heartrate_ttl(pet_chip_id, time, heart_rate) VALUES (123e4567-e89b-12d3-a456-426655440b23, '2019-03-04 07:04:00', 131);

UPDATE heartrate_ttl USING TTL 2000 SET heart_rate=131 WHERE pet_chip_id=123e4567-e89b-12d3-a456-426655440b23 AND time = '2019-03-04 07:04:00';

SELECT pet_chip_id,time, heart_rate, TTL(heart_rate) from heartrate_ttl;