In Cassandra we have minTimeuuid() and maxTimeuuid() methods that aeturns a UUID -like result given a conditional time component as an argument. For example:
SELECT * FROM myTable
WHERE t > maxTimeuuid('2013-01-01 00:05+0000')
AND t < minTimeuuid('2013-02-02 10:00+0000')
Please reply , and tell me is it good idea to have uuidv1 as document key and use maxTimeuuid and minTimeuuid (I have implemented both in application side) to range query?
@vsr1 I want to choose a unique key , so I want to have UUID V1 as key
The client side application get a list of docs and for pagination , I dont use offset and limite , instead client send last Id of doc as offset and in server side we do