incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jan Algermissen <jan.algermis...@nordsc.com>
Subject Re: paging through a table with timeuuid primary key
Date Tue, 01 Oct 2013 16:18:51 GMT
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 <y2klyf+work@gmail.com> wrote:

> 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 working for token
function?
>  
> 
> 
> On Tue, Oct 1, 2013 at 8:57 AM, David Ward <david@shareablee.com> wrote:
> 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 <jan.algermissen@nordsc.com> wrote:
> Jimmy,
> 
> On 01.10.2013, at 17:26, Jimmy Lin <y2klyf+work@gmail.com> 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 support:
> 
> http://www.datastax.com/dev/blog/client-side-improvements-in-cassandra-2-0
> 
> Jan
> 
> >
> > select * from log where token(mykey) > token(maxTimeuuid(xxxxx)) limit 100;
> >
> 
> 
> > (where xxx is 0 for the first query, and next one to be the time of the mykey(timeuuid)
from the last query result)
> >
> > But i seem to get random result.
> >
> > #1
> > is the above logic make sense for timeuuid type pagination?
> >
> > #2
> > when we use token in the where clase, is the result return sorted?
> > e.g
> > where token(k) > token(4) AND token(k)  < token(10) limit 3
> >
> > k=5, k=6, k=7
> > or
> > k=7, k=5, k=9
> >
> > ?
> >
> > I see lot of article use LIMIT to achieve page size, but if the result is not sorted,
then it is possible to miss item?
> >
> >
> > thanks
> >
> >
> 
> 
> 


Mime
View raw message