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 15:30:54 GMT
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