[HBASE-2438] Addition of a Column Pagination Filter

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.20.3
• Fix Version/s: 0.90.0
• Component/s: Filters
• Hadoop Flags: Reviewed

Release Note

 * A filter, based on the ColumnCountGetFilter, takes two arguments: limit and offset.
 * This filter can be used for row-based indexing, where references to other tables are stored across many columns, in order to efficient lookups and paginated results for end users.

• Tags: pagination, "row-based indexing", filter
• Assignee: Paul Kist
• Reporter: Paul Kist
• Created: 13/Apr/10 15:42
• Updated: 20/Nov/15 12:43
• Resolved: 20/Apr/10 21:30

Description

Client applications may need to do pagination, depending on the number of columns returned, it may be more efficient to perform pagination algorithms at the database level (similar to SQL's LIMIT and OFFSET). This will be an additional filter taking two parameters:

• page
• pageSize

For every row, that gets returned, only a subset of columns are returned based on page and pageSize

If the page / pageSize column goes over the limits, then no results are returned from the filter.

A practical example for using a filter like this may be for folks doing Row-based indexing with Hbase.