HI Team,

I have one table below and want to delete data on this table.


DELETE  FROM game.tournament USING TIMESTAMP 1616925780000000 WHERE
tournament_id = 1 AND version_id = 1 AND partition_id = 1;


Cassandra internally manages the timestamp of each column when some data is
updated on the same column.


My Query is , *USING TIMESTAMP 1616925780000000* picks up a timestamp of
which column ?



CREATE TABLE game.tournament (

    tournament_id bigint,

    version_id bigint,

    partition_id bigint,

    user_id bigint,

    created_at timestamp,

    rank bigint,

    score bigint,

    updated_at timestamp,

    PRIMARY KEY ((tournament_id, version_id, partition_id), user_id)

) WITH CLUSTERING ORDER BY (user_id ASC)







-- 
Raman Gugnani

Reply via email to