I created table using the command:
CREATE TABLE correlated_data (
processing_timestamp bigint,
generating_timestamp bigint,
data text,
PRIMARY KEY (processing_timestamp, generating_timestamp)
) WITH CLUSTERING ORDER BY (generating_timestamp DESC);
When I get data using the command :
SELECT * FROM correlated_data LIMIT 1 ;
I expect it return the row with the biggest field "generating_timestamp",
but I got the same row every time I run the query, while row with bigger "
generating_timestamp" exists. What's the problem?