I don't understand why my rows are not ordered as I specified during table creation with the clustering columns. I have a table defined as
CREATE TABLE streaming_test.test_payload_by_sensor ( sensor_id uuid, date date, timestamp timestamp, altitude decimal, ... ... ... PRIMARY KEY ((sensor_id, date), timestamp) ) WITH CLUSTERING ORDER BY (timestamp DESC)
However, I see the values:
sensor_id | date | timestamp |
---|---|---|
sensor001 | 2021-10-03 | 2021-10-03 11:55:00.000000+0000 |
sensor001 | 2021-10-12 | 2021-10-12 10:45:00.000000+0000 |
sensor001 | 2021-10-12 | 2021-10-12 10:35:00.000000+0000 |
sensor001 | 2021-10-12 | 2021-10-12 10:30:00.000000+0000 |
Shouldn't the first value be last?