Cassandra -如何检索最近的值

CREATE TABLE events (
    event_id UUID PRIMARY KEY,
    description TEXT,
    timestamp TIMESTAMP
);

SELECT * FROM events ORDER BY timestamp DESC LIMIT 1;

from cassandra.cluster import Cluster
from cassandra.query import SimpleStatement
from uuid import uuid4
from datetime import datetime

# 连接到 Cassandra 集群
cluster = Cluster(['127.0.0.1'])
session = cluster.connect('your_keyspace')

# 插入数据
event_id = uuid4()
description = "Sample event"
timestamp = datetime.now()
insert_stmt = session.prepare("INSERT INTO events (event_id, description, timestamp) VALUES (?, ?, ?)")
session.execute(insert_stmt, [event_id, description, timestamp])

# 检索最近的值
select_stmt = session.prepare("SELECT * FROM events ORDER BY timestamp DESC LIMIT 1")
result = session.execute(select_stmt)
for row in result:
    print(row.event_id, row.description, row.timestamp)

# 关闭连接
cluster.shutdown()