Does Riak support Range Queries over binary safe strings?
gbrits at gmail.com
Tue Jul 16 19:13:20 EDT 2013
Wow, high speed on this list!
I wanted it for near realtime anyway so Map/reduce is out of the question.
Thought somehow it could be done through Riak Search or directly on
secondary indices instead of map/reduce.
Guess not. Oh well, can't have it all.
2013/7/17 Jeremiah Peschka [via Riak Users] <
ml-node+s197444n4028359h32 at n3.nabble.com>
> Following up on Alex's comments -
> If you know which bytes you need to slice, you can store this in a
> secondary index. You can perform range queries across secondary indices (as
> well as keys).
> As long as you're storing your data in a way that allows it to be read by
> MapReduce. This is typically regarded as a Bad Idea™ since an MR query will
> need to scan all keys in a bucket (which effectively means scanning the
> entire cluster) and is best done as an infrequent activity to transform
> Jeremiah Peschka - Founder, Brent Ozar Unlimited
> MCITP: SQL Server 2008, MVP
> Cloudera Certified Developer for Apache Hadoop
> On Tue, Jul 16, 2013 at 3:45 PM, Alexander Sicular <[hidden email]<http://user/SendEmail.jtp?type=node&node=4028359&i=0>
> > wrote:
>> I would say no. Riak is generally oblivious as to the content of your
>> data. Any ranges or other method you would use to query needs to be
>> explicitly indexed via riak search or secondary indexes. Once you have
>> found your data you could operate over that data in a map reduce, but I
>> although I'm inclined to say yes, you would be able to operate over it in
>> So searching for keys with certain data in the binblob is probably not
>> gonna happen but once you have a key to feed an m/r you could get a slice
>> of that value.
>> Make sense?
>> Sent from my iRotaryPhone
>> On Jul 16, 2013, at 18:17, gbrits <[hidden email]<http://user/SendEmail.jtp?type=node&node=4028359&i=1>>
>> > First, hello all!
>> > Coming from Redis, I love that you can just put any binary blob in Redis
>> > which is just treated as a string. This is possible because Redis
>> > are what they call 'binary safe'. This makes it possible to return
>> slices of
>> > string-encoded binary data, which is super useful for bitset-operations,
>> > etc.
>> > I'm investigating Riak and I like it a lot so far. Riak seems to have
>> > queries (on values, as it seems I must make that distinction with
>> > column-stores), but I'm not sure if strings in Riak are "Binary safe"
>> in the
>> > above sense. If not, is there another way to store binary data in Riak
>> > still do range queries over them quickly?
>> > To be exact: I want to do multi-key lookups in Riak, where each returned
>> > result should be of format: <key,slice(featureX,start,end)>
>> > Thanks,
>> > Geert-Jan
>> > --
>> > View this message in context:
>> > Sent from the Riak Users mailing list archive at Nabble.com.
>> > _______________________________________________
>> > riak-users mailing list
>> > [hidden email] <http://user/SendEmail.jtp?type=node&node=4028359&i=2>
>> > http://lists.basho.com/mailman/listinfo/riak-users_lists.basho.com
>> riak-users mailing list
>> [hidden email] <http://user/SendEmail.jtp?type=node&node=4028359&i=3>
> riak-users mailing list
> [hidden email] <http://user/SendEmail.jtp?type=node&node=4028359&i=4>
> If you reply to this email, your message will be added to the discussion
> To unsubscribe from Does Riak support Range Queries over binary safe
> strings?, click here<http://riak-users.197444.n3.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4028356&code=Z2JyaXRzQGdtYWlsLmNvbXw0MDI4MzU2fDExNjk3MTIyNTA=>
View this message in context: http://riak-users.197444.n3.nabble.com/Does-Riak-support-Range-Queries-over-binary-safe-strings-tp4028356p4028360.html
Sent from the Riak Users mailing list archive at Nabble.com.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the riak-users