Row pagination with HBase

Question

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

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

If that's not possible, how should I best design my rowkeys to query appropriately?

Answer 1

What about using the ColumnPaginationFilter?

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

Answer 2

You can make use of PageFilter to do that. When you create the instance of PageFilter, you specify a pageSize parameter, which controls how many rows per page should be returned.

Filter filter = new PageFilter(10);

And if you wish to do it through the HBase shell you can use LIMIT with your SCAN query :

scan 'table', LIMIT => 10