Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
HBase >> mail # user >> sorting by value


Copy link to this message
-
Re: sorting by value
Btw, liked the bit flipping for negative values. It didn't occur to me right off, it would be a problem

i Sent from my iPad with iMstakes

On Aug 30, 2012, at 23:14, "Tom Brown" <[EMAIL PROTECTED]> wrote:

> We do numerical sorting within some of our tables.  We put the numerical
> values as fixed length byte arrays within the keys (and flipped the sign
> bit so negative values are lexigraphically lower than positive values)
>
> Of course, it's still part of the key so that technique doesn't work for
> everyone, but it does allow us to do some limited sorting.
>
> --Tom
>
> On Thursday, August 30, 2012, Stack wrote:
>
>> On Tue, Aug 28, 2012 at 4:11 PM, Pamecha, Abhishek <[EMAIL PROTECTED]<javascript:;>>
>> wrote:
>>> Hi
>>>
>>> I probably know the usual answer but are there any tricks to do some
>> sort of sort by value in HBase. The only option I know is to somehow embed
>> value in the key part. The value is not a timestamp but a normal number.
>>>
>>> I want to find out, say, top 10 from a range of columns. The range could
>> be millions of columns. The range is dynamic for the most part.
>>>
>>> Any pointers?
>>>
>>
>>
>> HBase sorts by rows and then within a row by column family, column
>> qualifier, type, then timestamp.  You cannot have it natively sort
>> values for you, not unless you make the values be rows and/or columns
>> in another, separate table.
>>
>> St.Ack
>>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB