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