hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ted Yu <yuzhih...@gmail.com>
Subject Re: Getting all rows from .META. for a specific table.
Date Fri, 25 Apr 2014 12:13:04 GMT
Some post processing is needed to get the encoded region name. 

Cheers

On Apr 25, 2014, at 3:19 AM, David Koch <ogdude@googlemail.com> wrote:

> Hi, cool - thanks, it works nicely - taking this even further. Is there a
> way to get only the "plain text" region name - for instance, doing a plain
> scan results in something like:
> 
> my_table,\xA0\x03\x93\xC7\x81aBb\x8Cr\x1D\xB0\x93\x9D\x
> column=info:regioninfo, timestamp=1398333985425, value={NAME =>
> 'my_table,\xA0\x03\x93\xC7\x81aBb\x8Cr\x1D\xB0\x93\x9D\xBC\x0E,1392713217395.09326af68a5973257f8d88155
> BC\x0E,1392713217395.09326af68a5973257f8d881552f809cd.   2f809cd.',
> STARTKEY => '\xA0\x03\x93\xC7\x81aBb\x8Cr\x1D\xB0\x93\x9D\xBC\x0E', ENDKEY
> => '\xBF\xB9\x92\xA4N\x11C\x8E\x9A$a\xEF\xB2\xB7R\xC6', ENCODED =>
> 09326af68a5973
> 
> 257f8d881552f809cd,}
> 
> and all I require is "09326af68a5973257f8d881552f809cd" - which I believe
> is the HFile name. I currently extract this using some ugly stuff on the
> command line on the hbase shell output.
> 
> Thanks,
> 
> /David
> 
> 
> 
> On Fri, Apr 25, 2014 at 12:05 PM, Bharath Vissapragada <
> bharathv@cloudera.com> wrote:
> 
>> You can use a prefix filter something like as follows
>> 
>> hbase(main):013:0> scan '.META.', {FILTER => "PrefixFilter('t1')"}
>> 
>> Gives all the rows which corresponds to table 't1' as all the row keys
>> start with "t1".
>> 
>> 
>> On Fri, Apr 25, 2014 at 3:19 PM, David Koch <ogdude@googlemail.com> wrote:
>> 
>>> Hi,
>>> 
>>> How do I get all rows from .META. pertaining to a specific table? I don't
>>> want to scan all of .META. and then do a grep on the output since .META.
>> is
>>> quite large but I don't know how to use HBase filters from hbase shell.
>>> 
>>> Thanks,
>>> 
>>> /David
>> 
>> 
>> 
>> --
>> Bharath Vissapragada
>> <http://www.cloudera.com>
>> 

Mime
View raw message