question Re: Querying Hbase REST with special characters in rowkey in Support Questions

Querying Hbase REST with special characters in rowkey

EJB — Tue, 12 Jul 2022 13:09:07 GMT

Hi guys,

I need your assistance on querying hbase rest with special characters in the rowkey.

Hi, I have the following rowkey and data in Hbase:

ROW COLUMN+CELL \xF2member-00002 column=cf:age, timestamp=2022-07-12T10:16:11.986, value=20

I am querying using the REST interface (version 0.0.3) as:

GET 'http://localhost:8080/member/%F2member-00002'

but always getting Not found.

What should be the correct url encoded rowkey?

Thanks!

Re: Querying Hbase REST with special characters in rowkey

rki_ — Wed, 13 Jul 2022 14:35:40 GMT

Hello,

The encoded value for \x would be %5Cx. So can you try using it in the url. Is it connecting via Knox?

Also, do upload the curl command output.

Re: Querying Hbase REST with special characters in rowkey

EJB — Wed, 13 Jul 2022 16:48:27 GMT

Hi @rki_ ,

Thanks for the reply. I have also used standard url encoding but still getting no results. By the way, what is interesting is when I have the following data:

ROW COLUMN+CELL \xF2member-00002 column=cf:age, timestamp=2022-07-12T10:16:11.986, value=20 \x00member-00003 column=cf:age, timestamp=2022-07-12T10:16:11.986, value=20

I can query \x00member-00003 via curl by replacing \x with %

curl -v -X GET 'http://localhost:8080/member/%00member-00003' \ -H 'Accept: application/json' \ -H 'Content-Type: application/json'

and get results.

{ "Row": [ { "key": "AG1lbWJlci0wMDAwMw==", "Cell": [ { "column": "TTpwI2FnZQ==", "timestamp": 1657730533731, "$": "MjA=" } ] } ] }

but not this.

curl -v -X GET 'http://localhost:8080/member/%F2member-00002' \ -H 'Accept: application/json' \ -H 'Content-Type: application/json'

It returns Not Found.

Also, I am using an hbase standalone docker image (mckdev/hbase:2.4.12).

Re: Querying Hbase REST with special characters in rowkey

rki_ — Wed, 13 Jul 2022 17:55:32 GMT

Hello,

Based on the above test, I guess you are hitting HBASE-21852 which is still unresolved in the upstream.

Re: Querying Hbase REST with special characters in rowkey

EJB — Thu, 14 Jul 2022 02:56:49 GMT

hi @rki_ ,

This must be it.. thanks a lot for the info!