更新主键值Cassandra

-- 插入新记录
INSERT INTO your_keyspace.your_table (new_primary_key, column1, column2, ...)
VALUES (new_primary_key_value, value1, value2, ...);

-- 删除旧记录
DELETE FROM your_keyspace.your_table
WHERE old_primary_key = old_primary_key_value;

-- 插入新记录并设置TTL
INSERT INTO your_keyspace.your_table (new_primary_key, column1, column2, ...)
VALUES (new_primary_key_value, value1, value2, ...)
USING TTL 86400; -- TTL设置为24小时

-- 删除旧记录
DELETE FROM your_keyspace.your_table
WHERE old_primary_key = old_primary_key_value;

-- 插入新记录并使用LWT
INSERT INTO your_keyspace.your_table (new_primary_key, column1, column2, ...)
VALUES (new_primary_key_value, value1, value2, ...)
IF NOT EXISTS;

-- 删除旧记录并使用LWT
DELETE FROM your_keyspace.your_table
WHERE old_primary_key = old_primary_key_value
IF old_primary_key = old_primary_key_value;