> > 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.
As I mentioned previously, the UI only queries recent data, e.g., the past hour, past two hours, past day, past week. The UI does not query for anything older than the TTL which is 7 days. My understanding and expectation was that Cassandra would only scan live cells. The UI is a separate application that I do not maintain, so I am not 100% certain about the queries. I have been told that it does not query for anything older than 7 days. On Sun, Jan 29, 2017 at 4:14 AM, kurt greaves <k...@instaclustr.com> wrote: > > 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. > -- - John