Re: Unable to query with token range.. unable to make long from ‘...'

2014-09-28 Thread Kevin Burton
Got it.. and it works too.. …. select * from foo where token(hashcode) >= -9223372036854775808 and token(hashcode) <= -7378697629483820647 ; this should allow me to an easy distributed scan and analyze all the data in the database across machines.. On Sun, Sep 28, 2014 at 4:07 PM, graham sander

Re: Unable to query with token range.. unable to make long from ‘...'

2014-09-28 Thread graham sanderson
Looks like you are looking at old docs (pre Murmer3 partitioner). Latest are here (don’t think it has changed in 2.1 from 2.0.x) http://www.datastax.com/documentation/cassandra/2.1/cassandra/configuration/configGenTokens_c.html Murmer3 is definitely 64 bits On Sep 28, 2014, at 5:55 PM, Kevin Bu

Re: Unable to query with token range.. unable to make long from ‘...'

2014-09-28 Thread Kevin Burton
Hm.. is it 64 bits or 128 bits? I’m using Murmur3Partitioner … I can’t find any documentation on it (as usual.. ha) This says: http://www.datastax.com/docs/1.1/initialize/token_generation > The tokens assigned to your nodes need to be distributed throughout the entire possible range of tokens

Re: Unable to query with token range.. unable to make long from ‘...'

2014-09-28 Thread graham sanderson
It is expecting a 64 bit value … murmer3 partitioner uses 64 bit long tokens… where did you get your 128 bit long from, and what partitioner are you using? On Sep 28, 2014, at 1:39 PM, Kevin Burton wrote: > I’m trying to query an entire table in parallel by splitting it up in token > ranges. >

Unable to query with token range.. unable to make long from ‘...'

2014-09-28 Thread Kevin Burton
I’m trying to query an entire table in parallel by splitting it up in token ranges. However, it’s not working because I get this: cqlsh:blogindex> select token(hashcode), hashcode from source where token(hashcode) >= 0 and token(hashcode) <= 17014118346046923173168730371588410572 limit 10; Bad