incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jimmy Lin <y2klyf+w...@gmail.com>
Subject Re: paging through a table with timeuuid primary key
Date Tue, 01 Oct 2013 16:12:35 GMT
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