select * from test_paging where *token(*id*)* > token(0); ml
On Fri, Jun 6, 2014 at 1:47 AM, Jonathan Haddad <j...@jonhaddad.com> wrote: > Sorry, the datastax docs are actually a bit better: > http://www.datastax.com/documentation/cql/3.0/cql/cql_using/paging_c.html > > Jon > > > On Thu, Jun 5, 2014 at 10:46 PM, Jonathan Haddad <j...@jonhaddad.com> > wrote: > >> You should read through the token docs, it has examples and >> specifications: http://cassandra.apache.org/doc/cql3/CQL.html#tokenFun >> >> >> On Thu, Jun 5, 2014 at 10:22 PM, Kevin Burton <bur...@spinn3r.com> wrote: >> >>> I'm building a new schema which I need to read externally by paging >>> through the result set. >>> >>> My understanding from reading the documentation , and this list, is that >>> I can do that but I need to use the token() function. >>> >>> Only it doesn't work. >>> >>> Here's a reduction: >>> >>> >>> create table test_paging ( >>> id int, >>> primary key(id) >>> ); >>> >>> insert into test_paging (id) values (1); >>> insert into test_paging (id) values (2); >>> insert into test_paging (id) values (3); >>> insert into test_paging (id) values (4); >>> insert into test_paging (id) values (5); >>> >>> select * from test_paging where id > token(0); >>> >>> … but it gives me: >>> >>> Bad Request: Type error: cannot assign result of function token (type >>> bigint) to id (type int) >>> >>> … >>> >>> What's that about? I can't find any documentation for this and there >>> aren't any concise examples. >>> >>> >>> -- >>> >>> Founder/CEO Spinn3r.com >>> Location: *San Francisco, CA* >>> Skype: *burtonator* >>> blog: http://burtonator.wordpress.com >>> … or check out my Google+ profile >>> <https://plus.google.com/102718274791889610666/posts> >>> <http://spinn3r.com> >>> War is peace. Freedom is slavery. Ignorance is strength. Corporations >>> are people. >>> >>> >> >> >> -- >> Jon Haddad >> http://www.rustyrazorblade.com >> skype: rustyrazorblade >> > > > > -- > Jon Haddad > http://www.rustyrazorblade.com > skype: rustyrazorblade >
