Re: get all row keys of a table using CQL3

2013-07-24 Thread aaron morton
> I guess my question #1 still there, that does this query create a big load on > the initial node that receive such request because it still has to wait for > all the result coming back from other nodes before returning to client? sort of. The coordinator always has to wait. Only one node will

Re: get all row keys of a table using CQL3

2013-07-23 Thread Jimmy Lin
hi Blake, arh okay, token function is nice. But I am still bit confused by the word "page through all rows" select id from mytable where token(id) > token(12345) it will return all rows whose partition key's corresponding token that is > 12345 ? I guess my question #1 still there, that does this q

Re: get all row keys of a table using CQL3

2013-07-23 Thread Blake Eggleston
Hi Jimmy, Check out the token function: http://www.datastax.com/docs/1.1/dml/using_cql#paging-through-non-ordered-partitioner-results You can use it to page through your rows. Blake On Jul 23, 2013, at 10:18 PM, Jimmy Lin wrote: > hi, > I want to fetch all the row keys of a table using CQL3:

get all row keys of a table using CQL3

2013-07-23 Thread Jimmy Lin
hi, I want to fetch all the row keys of a table using CQL3: e.g select id from mytable limit 999 #1 For this query, does the node need to wait for all rows return from all other nodes before returning the data to the client(I am using astyanax) ? In other words, will this operation create a