table-basic-info-ttl-expire

INSERT INTO cycling.basic_info_TTL_expire (
  id, lastname, basics
) VALUES (
  e7ae5cf3-d358-4d99-b900-85902fda9bb0,
  'FRAME',
  {
    birthday : '1993-06-18',
    nationality : 'New Zealand',
    weight : '175',
    height : '72',
    next_race : 'Amgen Tour of California'
  }
)
USING TIMESTAMP 100 AND TTL 10000;

UPDATE cycling.basic_info_TTL_expire USING TTL 100
  SET basics =   {
    birthday : '1993-06-18',
    nationality : 'New Zealand',
    weight : '175',
    height : '72',
    next_race : 'Tour de France'
  }
WHERE id = e7ae5cf3-d358-4d99-b900-85902fda9bb0;

SELECT * FROM cycling.basic_info_ttl_expire;

SELECT WRITETIME(basics), TTL(basics) FROM cycling.basic_info_TTL_expire
WHERE id = e7ae5cf3-d358-4d99-b900-85902fda9bb0;

CREATE TABLE IF NOT EXISTS cycling.basic_info_ttl_expire (
  id UUID PRIMARY KEY,
  lastname text,
  basics frozen<basic_info_expire>
);

DESCRIBE TABLE cycling.basic_info_ttl_expire;

DROP TABLE IF EXISTS cycling.basic_info_ttl_expire;