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

Do not disable CBO by default when number of joins in a query is equal or less than 1

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 2.0.0
    • 2.0.0
    • CBO
    • None

    Description

      Instead, we could disable some parts of CBO that are not relevant if the query contains 1 or 0 joins. Implementation should be able to define easily other query patterns for which we might disable some parts of CBO (in case we want to do it in the future).

      Attachments

        1. HIVE-12017.01.patch
          12 kB
          jcamachorodriguez
        2. HIVE-12017.02.patch
          1.29 MB
          jcamachorodriguez
        3. HIVE-12017.03.patch
          2.93 MB
          jcamachorodriguez
        4. HIVE-12017.04.patch
          2.92 MB
          jcamachorodriguez
        5. HIVE-12017.05.patch
          3.53 MB
          jcamachorodriguez
        6. HIVE-12017.06.patch
          3.49 MB
          jcamachorodriguez
        7. HIVE-12017.07.patch
          3.49 MB
          jcamachorodriguez
        8. HIVE-12017.08.patch
          3.51 MB
          jcamachorodriguez
        9. HIVE-12017.09.patch
          3.48 MB
          jcamachorodriguez
        10. HIVE-12017.10.patch
          5.79 MB
          jcamachorodriguez
        11. HIVE-12017.11.patch
          5.79 MB
          jcamachorodriguez
        12. HIVE-12017.12.patch
          5.79 MB
          jcamachorodriguez
        13. HIVE-12017.13.patch
          5.81 MB
          jcamachorodriguez

        Issue Links

          duplicates

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-12040 CBO: Use CBO, even for the 1 JOIN + GROUP BY case

          • Major - Major loss of function.
          • Closed
          incorporates

          Bug - A problem which impairs or prevents the functions of the product. HIVE-12509 Regenerate q files after HIVE-12017 went in

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

          Bug - A problem which impairs or prevents the functions of the product. HIVE-12391 SkewJoinOptimizer might not kick in if columns are renamed after TableScanOperator

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. HIVE-12465 Hive might produce wrong results when (outer) joins are merged

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

          Bug - A problem which impairs or prevents the functions of the product. HIVE-12477 Left Semijoins are incompatible with a cross-product

          • Major - Major loss of function.
          • Closed
          links to

          Web Link RB link

          Activity

            People

              jcamacho Jesús Camacho Rodríguez
              jcamacho Jesús Camacho Rodríguez
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: