I recommend you to review newts data model, which is a time-series data model
upon cassandra:
https://github.com/OpenNMS/newts/wiki/DataModel
Sent using Zoho Mail
First the use-case: We have time-series of data from devices on several sites,
where each device (with a unique dev_id)
Approach (4) or (5) are what I would go for - they are (as your results
show) basically identical as the composite partition key gets converted
into a single hash.
Looking at your doc, I think the issue is you are using < operators on the
day field. As Cassandra doesn’t natively do range queries