Understanding Range queries with Random Partition

[Rana Aich <ai...@gmail.com>]

Hi,

I've used range queries for Order Preserving Partition and got the
satisfactory results.
For instance, I can find first 1 million keys that starts with key
'20080101000000' and ends with '20080102000000'.

Now I'm trying to do the same with Random Partitioning. But here I find that
for Range reads with RandomPartitioner I cannot set my end keys at all, or
else I get the InvalidRequestException(why:start key's md5 sorts after end
key's md5.  this is not allowed; you probably should not specify end key at
all, under RandomPartitioner)

So I set my end key to empty string.

Now I get the results - but they are not the first 1 million, rather the key
values are quite random. Infact I'm also getting keys from year 2009.

Is there any way I can find the keys restricted to 20080101 considering the
fact one day of our data contains 15 million records.

Regards,

Rana