I have a following table(using default sized tier compaction) that its column get TTLed every hour(as we want to keep only the last 1 hour events)
And I do Select * from mytable where object_id = ‘xxxx’ LIMIT 1; And since query only interested in last/latest value, will cassandra need to scan multiple sstables or potentially skipping tombstones data just to get the top of the latest data? Or is it smart enough to know the beginning of the sstables and get the result very efficiently? CREATE TABLE mytable ( object_id text, created timeuuid, my_data text PRIMARY KEY (object_id, created) ) WITH CLUSTERING ORDER BY (created DESC)