table-cyclist-sponsors
INSERT INTO cycling.cyclist_sponsors_expire (
cyclist_name, sponsorship
) VALUES (
'PRIETO, Marcela',
{ 'Castrelli', 'Alfa Romeo' }
)
USING TIMESTAMP 100
AND TTL 10000;
SELECT * FROM cycling.cyclist_sponsors_expire;
SELECT * FROM cycling.cyclist_sponsors_expire;
CREATE TABLE IF NOT EXISTS cycling.cyclist_sponsors_expire (
cyclist_name text PRIMARY KEY,
sponsorship set<text>
);
DESCRIBE TABLE cycling.cyclist_sponsors_expire;
DROP TABLE IF EXISTS cycling.cyclist_sponsors_expire;
UPDATE cycling.cyclist_sponsors_expire
USING TIMESTAMP 200 AND TTL 20000
SET sponsorship += { 'Tag Heuer' }
WHERE cyclist_name = 'PRIETO, Marcela';