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 sanderson <gra...@vast.com> wrote: > 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 Burton <bur...@spinn3r.com> wrote: > > 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 (0 to 2127 -1) > > so it would need to be 2^63 -1 or 2^127-1 > > > > On Sun, Sep 28, 2014 at 1:19 PM, graham sanderson <gra...@vast.com> wrote: > >> 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 <bur...@spinn3r.com> wrote: >> >> 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 Request: unable to make long from >> '17014118346046923173168730371588410572' >> >> … so I’m trying to figure out what’s going on here. >> >> Is there some magic I have to use to force the string representation of >> the 128 bit long into a token pointer? >> >> -- >> >> Founder/CEO Spinn3r.com <http://spinn3r.com/> >> Location: *San Francisco, CA* >> blog: http://burtonator.wordpress.com >> … or check out my Google+ profile >> <https://plus.google.com/102718274791889610666/posts> >> <http://spinn3r.com/> >> >> >> > > > -- > > Founder/CEO Spinn3r.com <http://spinn3r.com/> > Location: *San Francisco, CA* > blog: http://burtonator.wordpress.com > … or check out my Google+ profile > <https://plus.google.com/102718274791889610666/posts> > <http://spinn3r.com/> > > > -- Founder/CEO Spinn3r.com Location: *San Francisco, CA* blog: http://burtonator.wordpress.com … or check out my Google+ profile <https://plus.google.com/102718274791889610666/posts> <http://spinn3r.com>
