CODEWITHSUNDEEP
hbase
Jon Cardoso-Silva
Jon Cardoso-Silva

Reputation: 990

Row pagination with HBase

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?

Upvotes: 6

Views: 8420

Answers (2)

Ben Humphrey
Ben Humphrey

Reputation: 598

What about using the ColumnPaginationFilter?

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

Upvotes: -1

Tariq
Tariq

Reputation: 34184

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

Upvotes: 7

Related Questions