We are looking at using Cassandra to store a stream of information coming from various sources.
One issue we are facing is the best way to query between two dates.
For example we will need to retrieve an object between datetime dt1 and datetime dt2.
We are currently considering the created unix timestamp as the key pointing to the actual object then using get_key_range to query to retrieve?
Obviously this wouldn t work if two items have the same timestamp.
Is this the best way to do datetime in noSQL stores in general?