cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From aaron morton <>
Subject Re: how-to scan a table using CQL3
Date Tue, 14 May 2013 18:36:31 GMT
> 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.



Aaron Morton
Freelance Cassandra Consultant
New Zealand


On 11/05/2013, at 9:23 AM, Thorsten von Eicken <> 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:

View raw message