Display strings using HBase

Question

Is there a way to do pagination in HBase based on rowkeys?

I wanted to have the same effect as in SQL with SELECT * FROM table LIMIT 10 OFFSET 10 .

If this is not possible, what is the best way to tune my strings for the correct query?

Answer 1

You can use PageFilter for this . When you create an instance of PageFilter, you specify the pageSize parameter, which determines how many lines per page should be returned.

Filter Filter = new PageFilter (10);

And if you want to do this through the HBase shell, you can use LIMIT with a SCAN request:

scan table, LIMIT => 10

Answer 2

How about using a ColumnPaginationFilter?

 scan 't1', {FILTER => org.apache.hadoop.hbase.filter.ColumnPaginationFilter.new(<count>, <start_offset>)}