CREATE TABLE messages (
room_id uuid,
bucket_day date,
ts bigint,
msg_id uuid,
uid text,
content text,
PRIMARY KEY ((room_id, bucket_day), ts, msg_id)
) WITH CLUSTERING ORDER BY (ts ASC);