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

Update/delete/merge statements not optimized through CBO

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • None
    • 4.0.0-alpha-1
    • CBO
    • None

    Description

      Currently, CBO is bypassed for update/delete/merge statements.

      To support optimizing these statements through CBO, we need to complete three main tasks: 1) support for sort in Calcite planner, 2) support for SORT in AST converter, and 3) RewriteSemanticAnalyzer should extend CalcitePlanner instead of SemanticAnalyzer.

      Attachments

        1. HIVE-22785.15.patch
          2.40 MB
          Krisztian Kasa
        2. HIVE-22785.15.patch
          2.40 MB
          Krisztian Kasa
        3. HIVE-22785.15.patch
          2.40 MB
          Krisztian Kasa
        4. HIVE-22785.15.patch
          2.40 MB
          Krisztian Kasa
        5. HIVE-22785.14.patch
          2.40 MB
          Krisztian Kasa
        6. HIVE-22785.13.patch
          2.40 MB
          Krisztian Kasa
        7. HIVE-22785.12.patch
          2.49 MB
          Krisztian Kasa
        8. HIVE-22785.11.patch
          2.48 MB
          Krisztian Kasa
        9. HIVE-22785.10.patch
          2.42 MB
          Krisztian Kasa
        10. HIVE-22785.9.patch
          2.40 MB
          Krisztian Kasa
        11. HIVE-22785.8.patch
          2.39 MB
          Krisztian Kasa
        12. HIVE-22785.7.patch
          2.39 MB
          Krisztian Kasa
        13. HIVE-22785.6.patch
          136 kB
          Krisztian Kasa
        14. HIVE-22785.5.patch
          130 kB
          Krisztian Kasa
        15. HIVE-22785.4.patch
          131 kB
          Krisztian Kasa
        16. HIVE-22785.3.patch
          122 kB
          Krisztian Kasa
        17. HIVE-22785.2.patch
          94 kB
          Krisztian Kasa
        18. HIVE-22785.2.patch
          94 kB
          Krisztian Kasa
        19. HIVE-22785.1.patch
          90 kB
          Krisztian Kasa

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. HIVE-25109 CBO fails when updating table has constraints defined

          • Major - Major loss of function.
          • Resolved

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-23089 Add constraint checks to CBO plan

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-23094 Implement Explain CBO of Update and Delete statements

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-23135 Add RelDistribution trait to HiveSortExchange

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. HIVE-23119 Test sort_acid should be run by TestMiniLlapLocalCliDriver only

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

          Task - A task that needs to be done. HIVE-23130 User friendly error message when MV rewriting fails

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

          Task - A task that needs to be done. HIVE-23132 Add test of Explain CBO of Merge statements

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

          Web Link Review Board

          Activity

            People

              kkasa Krisztian Kasa
              jcamacho Jesús Camacho Rodríguez
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: