I am using Kundera 2.0.7 and Cassandra 1.0.8. I need to implement batching/ pagination over row keys.
for instance, Scan columnfamily , get 100 records in batch everytime , till all keys are exhausted.
I am using random partitioner for keyspace. I explored limit option in cql and ,setMaxresults() , but It doesnt give me ability to do range scan over row keys .
One option I can think of is Storing those row keys in separate column family as columns and do range queries on column.
Is there any best practice to achieve this ?
Any help ?