Re: how-to scan a table using CQL3

2013-08-26 Thread Alain RODRIGUEZ
table scans as simple as "select * from ". > Anyone try this yet? > > From: Alain RODRIGUEZ > Reply-To: "user@cassandra.apache.org" > Date: Thursday, August 22, 2013 11:01 AM > To: "user@cassandra.apache.org" > Subject: Re: how-to scan a ta

Re: how-to scan a table using CQL3

2013-08-26 Thread Keith Wright
.com>> Reply-To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" mailto:user@cassandra.apache.org>> Date: Thursday, August 22, 2013 11:01 AM To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" mailto:user@cassandra.apache.org&

Re: how-to scan a table using CQL3

2013-08-22 Thread Alain RODRIGUEZ
Oops, I made a mistake thought I was paging on partition key when I actually was paging on columns. No need of token and columns are ordered. Sorry about bothering the ones who read this, it was a PEBCAK. Alain 2013/8/21 Alain RODRIGUEZ > Hi, I am sorry about digging this up but I was in sea

Re: how-to scan a table using CQL3

2013-08-21 Thread Alain RODRIGUEZ
Hi, I am sorry about digging this up but I was in search of this kind of information and read this thread. How to make sure that the first rowkey you select has the smaller token ? I mean when you perform "select rowkey from my_table limit N;" can you have any data with any token or is data token

Re: how-to scan a table using CQL3

2013-05-14 Thread aaron morton
> 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 -

Re: how-to scan a table using CQL3

2013-05-10 Thread Thorsten von Eicken
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 impleme

Re: how-to scan a table using CQL3

2013-05-10 Thread Keith Wright
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