incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kevin Burton <bur...@spinn3r.com>
Subject Re: Bad Request: Type error: cannot assign result of function token (type bigint) to id (type int)
Date Fri, 06 Jun 2014 19:31:56 GMT
Thanks!! Yes. I completely missed that.  Not sure why… :)

Appreciate the help!


On Fri, Jun 6, 2014 at 2:59 AM, Laing, Michael <michael.laing@nytimes.com>
wrote:

> select * from test_paging where *token(*id*)* > token(0);
>
> ml
>
>
> On Fri, Jun 6, 2014 at 1:47 AM, Jonathan Haddad <jon@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 <jon@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 <burton@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
>>
>
>


-- 

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.

Mime
View raw message