Re: paging through a table with timeuuid primary key

2013-10-01 Thread Jimmy Lin
ok found out the problem.. i was using something like: select * from log where token(mykey) > token(maxTimeuuid(x)) limit 100; instead I should just simply use select * from log where token(mykey) > token(key_from_last_result) limit 100; the fake timeuuid although represent the time from la

Re: paging through a table with timeuuid primary key

2013-10-01 Thread Jimmy Lin
thanks, yea i am aware of that, and have already taken care. I just also found out a similar thread back in June http://mail-archives.apache.org/mod_mbox/cassandra-user/201306.mbox/%3ccakkz8q2no6oucbwnveomn_ymxfh0nkpqvtym55jmvwa2qwx...@mail.gmail.com%3E Somone was saying Long story short, usin

Re: paging through a table with timeuuid primary key

2013-10-01 Thread Jan Algermissen
Maybe you are hitting the problem that your 'pages' can get truncated in the middle of a wide row. See https://groups.google.com/a/lists.datastax.com/d/msg/java-driver-user/lHQ3wKAZgM4/DnlXT4IzqsQJ Jan On 01.10.2013, at 18:12, Jimmy Lin wrote: > unfortunately, i have to stick with 1.2 for

Re: paging through a table with timeuuid primary key

2013-10-01 Thread Jimmy Lin
unfortunately, i have to stick with 1.2 for now for a while. So I am looking for the old fashion way to do the pagination correctly. I think i follow most of the articles on how to paging through a table, but maybe have some silly gap that don't give me the correct behavior or it is timeuuid not

Re: paging through a table with timeuuid primary key

2013-10-01 Thread David Ward
2.0 has a lot of really exciting stuff, unfortunately 2.0 has a lot of really exciting stuff that may increase the risk of updating to 2.0 just yet. On Tue, Oct 1, 2013 at 9:30 AM, Jan Algermissen wrote: > Jimmy, > > On 01.10.2013, at 17:26, Jimmy Lin wrote: > > > i have a table like the follow

Re: paging through a table with timeuuid primary key

2013-10-01 Thread Jan Algermissen
Jimmy, On 01.10.2013, at 17:26, Jimmy Lin wrote: > i have a table like the following: > > CREATE TABLE log ( > mykey timeuuid, > type text, > msg text, > primary key(mykey, type) > ); > > I want to page through all the results from the table using Have you considered the new build-in paging

paging through a table with timeuuid primary key

2013-10-01 Thread Jimmy Lin
i have a table like the following: CREATE TABLE log ( mykey timeuuid, type text, msg text, primary key(mykey, type) ); I want to page through all the results from the table using select * from log where token(mykey) > token(maxTimeuuid(x)) limit 100; (where xxx is 0 for the first query, and