Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-11573

PointLookupOptimizer can be pessimistic at a low nDV

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.0.0
    • Fix Version/s: 2.0.0
    • Component/s: None
    • Labels:
      None
    • Release Note:
      Provide configurable limits to the PointLookupOptimizer

      Description

      The PointLookupOptimizer can turn off some of the optimizations due to its use of tuple IN() clauses.

      Limit the application of the optimizer for very low nDV cases and extract the sub-clause as a pre-condition during runtime, to trigger the simple column predicate index lookups.

        Attachments

        1. HIVE-11573.6.patch
          108 kB
          Gopal Vijayaraghavan
        2. HIVE-11573.5.patch
          106 kB
          Jesus Camacho Rodriguez
        3. HIVE-11573.4.patch
          40 kB
          Gopal Vijayaraghavan
        4. HIVE-11573.3.patch
          37 kB
          Gopal Vijayaraghavan
        5. HIVE-11573.2.patch
          8 kB
          Gopal Vijayaraghavan
        6. HIVE-11573.1.patch
          8 kB
          Gopal Vijayaraghavan

          Issue Links

            Activity

              People

              • Assignee:
                gopalv Gopal Vijayaraghavan
                Reporter:
                gopalv Gopal Vijayaraghavan
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: