question Re: Combine few hbase shell commands in Archives of Support Questions (Read Only)

Combine few hbase shell commands

n3_apple — Tue, 21 Jun 2016 19:03:49 GMT

Hey,

I have a hbase table with 4 columns. I want to search for a string in column1 and get the value of column2 from every row, where I get a match. I works with these two codelines

scan 'table', { COLUMNS => 'column1', FILTER => "ValueFilter(=, 'substring:value')"}

Then foreach row: get 'table', $row, {COLUMNS => 'column2'}

How can I get the result (e.g. 'value1, value2, value3') by executing only one command?

best regards

J.H.

Re: Combine few hbase shell commands

tyu — Tue, 21 Jun 2016 20:22:44 GMT

You can use SingleColumnValueFilter on 'column1'

Meanwhile, specify all the columns you want to retrieve using COLUMNS.

Re: Combine few hbase shell commands

n3_apple — Tue, 21 Jun 2016 20:42:43 GMT

@Ted Yu

Thank you for the help. Maybe you can give me an example how to use it, because I get only errors and the examples which I found are not for the shell.

Re: Combine few hbase shell commands

tyu — Tue, 21 Jun 2016 21:05:21 GMT

Please take a look at hbase-shell//src/test/ruby/hbase/table_test.rb for sample syntax where x is column family:

@test_table._scan_internal(FILTER => "SingleColumnValueFilter('x', 'a', >=, 'binary:\x82', true, true)", COLUMNS => 'x:a, x:b'