> select rowkey from my_table limit N; > while some_row_is_returned do > select rowkey from my_table where token(rowkey) > > token(last_rowkey_returned) limit N;
That should work for you. See http://www.datastax.com/docs/1.2/cql_cli/using/paging#non-ordered-partitioner-paging Cheers ----------------- Aaron Morton Freelance Cassandra Consultant New Zealand @aaronmorton http://www.thelastpickle.com On 11/05/2013, at 9:23 AM, Thorsten von Eicken <t...@rightscale.com> wrote: > Thanks, this is interesting, but if I'm not mistaken, Astyanax uses CQL2. I'm > trying to find a CQL3 solution on top the binary protocol. There has to be a > way to do this in CQL3...? > Thorsten > > > > On 5/10/2013 1:33 PM, Keith Wright wrote: >> What you are proposing should work and I started to implement that using >> multiple threads over the token ranges but decided instead to use to >> Astyanax's read all rows recipe as it does much of that already. It >> required some work to convert the composite CQL2 format returned from >> Astayanx into what is expected for CQL3 but did work. Here's an outline >> of what you would do: >> >> >