incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From aaron morton <aa...@thelastpickle.com>
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.

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 <tve@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:
>> 
>> 
> 


Mime
View raw message