incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Ward <da...@shareablee.com>
Subject Re: paging through a table with timeuuid primary key
Date Tue, 01 Oct 2013 15:57:11 GMT
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