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?