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

Use batching when joining data table rows with uncovered local index rows

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 4.16.1, 5.1.2
    • 4.17.0, 5.2.0, 5.1.3
    • None
    • None

    Description

      The current solution uses HBase get operations to join data table rows with uncovered local index rows on the server side. Issuing a separate get operation for every data table row can be expensive. Instead, we can buffer lots of data row keys in memory and use a scan with skip scan filter. This will reduce the cost of join and also improve the performance.

      Attachments

        Issue Links

          Blocked

          Improvement - An improvement or enhancement to an existing feature or task. PHOENIX-6501 Use batching when joining data table rows with uncovered global index rows

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

          Improvement - An improvement or enhancement to an existing feature or task. PHOENIX-6412 Consider batching uncovered column merge for local indexes

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved
          links to

          Web Link GitHub Pull Request #1403

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: