Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-6068

(5.x) Read repair reduces the number of rows returned for LIMIT queries

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Blocker
    • Resolution: Fixed
    • 5.0.0, 4.14.3
    • 5.1.0
    • None
    • None

    Description

      Phoenix uses HBase PageFilter to limit the number of rows returned by scans. If a scanned index row is unverified, GlobalIndexChecker repairs this rows. This repair operation leads to either skipping the unverified row or scanning its repaired version. Every scanned row including unverified rows are counted by the page filter. Since unverified rows are counted but not returned for the query, the actual number of rows returned for a LIMIT query becomes less than the set limit (i.e., page size) for the query.

      Attachments

        Issue Links

          is a clone of

          Bug - A problem which impairs or prevents the functions of the product. PHOENIX-5969 Read repair reduces the number of rows returned for LIMIT queries

          • Major - Major loss of function.
          • Resolved
          is blocked by

          Improvement - An improvement or enhancement to an existing feature or task. PHOENIX-5881 Port MaxLookbackAge logic to 5.x

          • Blocker - Blocks development and/or testing work, production could not run
          • Closed

          Activity

            People

              Unassigned Unassigned
              kozdemir Kadir OZDEMIR
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: