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

Improve Hive/Calcite Transitive Predicate inference

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 2.0.0, 2.1.0
    • 2.1.0
    • CBO
    • None

    Description

      HiveJoinPushTransitivePredicatesRule does not pull up predicates for transitive inference if they contain more than one column.

      EXPLAIN select * from srcpart join (select ds as ds, ds as `date` from srcpart where  (ds = '2008-04-08' and value=1)) s on (srcpart.ds = s.ds);

      Attachments

        1. HIVE-12478.01.patch
          42 kB
          jcamachorodriguez
        2. HIVE-12478.02.patch
          44 kB
          jcamachorodriguez
        3. HIVE-12478.03.patch
          241 kB
          jcamachorodriguez
        4. HIVE-12478.04.patch
          237 kB
          jcamachorodriguez
        5. HIVE-12478.05.patch
          1.05 MB
          jcamachorodriguez
        6. HIVE-12478.06.patch
          1.02 MB
          jcamachorodriguez
        7. HIVE-12478.07.patch
          27 kB
          jcamachorodriguez
        8. HIVE-12478.08.patch
          1.08 MB
          jcamachorodriguez
        9. HIVE-12478.09.patch
          1.09 MB
          jcamachorodriguez
        10. HIVE-12478.10.patch
          1.51 MB
          jcamachorodriguez
        11. HIVE-12478.11.patch
          1.20 MB
          jcamachorodriguez
        12. HIVE-12478.12.patch
          1.24 MB
          jcamachorodriguez
        13. HIVE-12478.patch
          25 kB
          jcamachorodriguez

        Issue Links

          is related to

          Sub-task - The sub-task of the issue HIVE-12543 Disable Hive ConstantPropagate optimizer when CBO has optimized the plan

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

          Bug - A problem which impairs or prevents the functions of the product. HIVE-11110 Reorder applyPreJoinOrderingTransforms, add NotNULL/FilterMerge rules, improve Filter selectivity estimation

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

          Web Link RB link

          Activity

            People

              jcamacho Jesús Camacho Rodríguez
              jpullokkaran Laljo John Pullokkaran
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: