Your partitioning key is text. If you have multiple entries per id you are likely hitting older cells that have expired. Descending only affects how the data is stored on disk, if you have to read the whole partition to find whichever time you are querying for you could potentially hit tombstones in other SSTables that contain the same "id". As mentioned previously, you need to add a time bucket to your partitioning key and definitely use DTCS/TWCS.
- Time series data model and tombstones John Sanda
- Re: Time series data model and tombstones DuyHai Doan
- Re: Time series data model and tombstones Jonathan Haddad
- Re: Time series data model and tombstones John Sanda
- Re: Time series data model and tombstones Benjamin Roth
- Re: Time series data model and tombstones kurt greaves
- Re: Time series data model and tombs... John Sanda
- Re: Time series data model and t... DuyHai Doan
- Re: Time series data model a... John Sanda
- Re: Time series data model a... DuyHai Doan
- Re: Time series data model a... John Sanda
- Re: Time series data model a... DuyHai Doan
- Re: Time series data model a... John Sanda
- Re: Time series data model a... DuyHai Doan
- Re: Time series data model a... John Sanda
- Re: Time series data model a... DuyHai Doan