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

CBO: Use CBO, even for the 1 JOIN + GROUP BY case

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Duplicate
    • 1.3.0, 2.0.0
    • 1.3.0, 2.0.0
    • Logical Optimizer
    • None

    Description

      Hive CBO kicks in for a query only if a query has >1 joins, which is an archaic result of only re-ordering joins in the original impl.

      As more group-by & filter optimizers have been added, modify the CBO impl to kick in even if the query has a single JOIN.

      Attachments

        Issue Links

          is duplicated by

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-12017 Do not disable CBO by default when number of joins in a query is equal or less than 1

          • Major - Major loss of function.
          • Closed

          Activity

            People

              gopalv Gopal Vijayaraghavan
              gopalv Gopal Vijayaraghavan
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: