Retrieving a row from value on HBase Shell

data_ali — Wed, 18 Nov 2020 19:54:47 GMT

I have to retrieve information from all columns of a row based on a given value.

the data is

fname - John

lname - Andrews

snumber - 008

degree - MIT

I have this query that returns only the degree column:
scan 'CWRK', {COLUMNS => 'STUDENT', FILTER => "ValueFilter ( =, 'binaryprefix:MIT')"}

this gives the result:
student:008 column=STUDENT:degree, timestamp = ......... , value=MIT

I want to run a query that returns values for all 4 attributes (fname, lname, snumber, degree) for the row-number student:008 as that is the row that has the MIT value for degree key.

Can this be done?

Re: Retrieving a row from value on HBase Shell

data_ali — Thu, 19 Nov 2020 00:19:51 GMT

I got it working with SingleColumnValueFilter

scan 'CWRK', {FILTER => "SingleColumnValueFilter = ('STUDENT','degree',=,'binary:MIT',true,true)"}

question Re: Retrieving a row from value on HBase Shell in Support Questions

Retrieving a row from value on HBase Shell

Re: Retrieving a row from value on HBase Shell