HBase
  1. HBase
  2. HBASE-2438

Addition of a Column Pagination Filter

    Details

    • Type: New Feature New Feature
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 0.20.3
    • Fix Version/s: 0.90.0
    • Component/s: Filters
    • Labels:
      None
    • Hadoop Flags:
      Reviewed
    • Release Note:
      Hide
       * 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.
      Show
       * 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

      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.

        Activity

        Paul Kist created issue -
        Andrew Purtell made changes -
        Field Original Value New Value
        Fix Version/s 0.20.3 [ 12314357 ]
        Paul Kist made changes -
        Attachment hbase-2438-0.20.3.patch [ 12441650 ]
        Jonathan Gray made changes -
        Assignee Paul Kist [ kida78 ]
        Paul Kist made changes -
        Attachment hbase-2438-0.20.3-v2.patch [ 12441747 ]
        Paul Kist made changes -
        Attachment hbase-2438-0.20.3-v3.patch [ 12441774 ]
        Paul Kist made changes -
        Status Open [ 1 ] Patch Available [ 10002 ]
        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.
        stack made changes -
        Status Patch Available [ 10002 ] Resolved [ 5 ]
        Hadoop Flags [Reviewed]
        Fix Version/s 0.20.5 [ 12314800 ]
        Fix Version/s 0.21.0 [ 12313607 ]
        Resolution Fixed [ 1 ]
        stack made changes -
        Fix Version/s 0.20.5 [ 12314800 ]

          People

          • Assignee:
            Paul Kist
            Reporter:
            Paul Kist
          • Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Time Tracking

              Estimated:
              Original Estimate - 8h
              8h
              Remaining:
              Remaining Estimate - 8h
              8h
              Logged:
              Time Spent - Not Specified
              Not Specified

                Development