HBASE row prefix scan in reverse order in hbase

hbase hbase-shell
tanbog picture tanbog · Sep 29, 2016 · Viewed 7.4k times · Source

I have a row key of the form:

<name>--<zero-padded timestamp>

Using HBASE shell I want to find last 15 entries with the prefix .

scan 'mytable', {LIMIT => 15, ROWPREFIXFILTER => 'name' }

Gives me the first 15, but:

scan 'mytable', {LIMIT => 15, REVERSED => TRUE, ROWPREFIXFILTER => 'name'}

returns zero results...

What is the syntax for such a request?

Is it possible, or do I have to do something cheesy like use MAXINT-timestamp as my rowkey to manually reverse the key ordering?

Answer

Armstrongya picture Armstrongya · Oct 18, 2016

I can execute your query command in HBase shell environment, and get the expected result. But couldn't get any result throw Java Client. My HBase version is 0.98.

There is a bug when use HBase client scan with reversed = true, see this jira issue hbase-client: scanner with reversed=true and small=true get no result

Related questions

HBase (Easy): How to Perform Range Prefix Scan in hbase shell

I am designing an app to run on hbase and want to interactively explore the contents of my cluster. I am in the hbase shell and I want to perform a scan of all keys starting with the chars "abc". …

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

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":"...

Read More
Export data from HBase shell

Im trying to export data from HBase Shell to a text file which I can parse, and add to a msysql db. I am currently using the following command: echo "scan 'registration',{COLUMNS=>'registration:status'}" | hbase shell > registration.…

Read More