Re: token(), limit and wide rows

2013-08-17 Thread Richard Low
You can do it by using two types of query. One using token as you suggest, the other by fixing the partition key and walking through the other parts of the composite primary key. For example, consider the table: create table paging (a text, b text, c text primary key (a, b)); I inserted ('1',

Re: token(), limit and wide rows

2013-08-16 Thread Keith Freeman
I've run into the same problem, surprised nobody's responded to you. Any time someone asks how do I page through all the rows of a table in CQL3?, the standard answer is token() and limit. But as you point out, this method will often miss some data from wide rows. Maybe a Cassandra expert

token(), limit and wide rows

2013-08-13 Thread Jan Algermissen
HI, ok, so I found token() [1], and that it is an option for paging through randomly partitioned data. I take it that combining token() and LIMIT is the CQL3 idiom for paging (set aside the fact that one shouldn't raelly want to page and use C*) Now, when I page through a CF with wide rows,