How do I get a Row with HBASE Shell where the rowkey is in Hexadecimal?

Kyle Brandt picture Kyle Brandt · Sep 17, 2013 · Viewed 25.5k times · Source

If I have a rowkey that is in Hexadecimal, like x00\x01 , how do I get that in the HBASE shell?

hbase(main):004:0> scan 'tsdb-tree'
ROW                 COLUMN+CELL
\x00\x01            column=t:tree, timestamp=1379421652764, value={"name":"...

Answer

Kyle Brandt picture Kyle Brandt · Sep 17, 2013

You can reference it using a normal get command, but the hexadecimal key must be in double quotes, single quotes will not work:

For example you would use get 'tsdb-tree', "\x00\x01":

hbase(main):016:0> scan 'tsdb-tree'
ROW                                                                       COLUMN+CELL                                                                                                                                                                                                             
 \x00\x01                                                                 column=t:tree, timestamp=1379421652764, value={"name":"TestTree1","description":"","notes":"","strictMatch":false,"created":0,"enabled":false,"storeFailures":false}                                                    
 \x00\x01                                                                 column=t:tree_rule:0:0, timestamp=1379371753132, value={"type":"METRIC","field":"host","regex":"","separator":"","description":"","notes":"","level":0,"order":0,"treeId":1,"customField":"","regexGroupIdx":0,"displayF
                                                                          ormat":""}                                                                                                                                                                                                              
 \x00\x02                                                                 column=t:tree, timestamp=1379372909057, value={"name":"testTree2","description":"","notes":"","strictMatch":false,"created":0,"enabled":false,"storeFailures":false}                                                    
2 row(s) in 0.0300 seconds

hbase(main):017:0> get 'tsdb-tree', "\x00\x01"
COLUMN                                                                    CELL                                                                                                                                                                                                                    
 t:tree                                                                   timestamp=1379421652764, value={"name":"TestTree1","description":"","notes":"","strictMatch":false,"created":0,"enabled":false,"storeFailures":false}                                                                   
 t:tree_rule:0:0                                                          timestamp=1379371753132, value={"type":"METRIC","field":"host","regex":"","separator":"","description":"","notes":"","level":0,"order":0,"treeId":1,"customField":"","regexGroupIdx":0,"displayFormat":""}              
2 row(s) in 0.0140 seconds