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

genNotNullFilterForJoinSourcePlan: needs to merge predicates into the multi-AND

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 2.1.0
    • 2.1.0
    • Logical Optimizer
    • None

    Description

      predicate: ((cbigint is not null and cint is not null) and cint BETWEEN 1000000 AND 3000000) (type: boolean)

      does not fold the IS_NULL on cint, because of the structure of the AND clause.

      For example, see tez_dynpart_hashjoin_1.q

      Attachments

        1. HIVE-12968.1.patch
          10 kB
          Gopal Vijayaraghavan
        2. HIVE-12968.2.patch
          653 kB
          Gopal Vijayaraghavan
        3. HIVE-12968.3.patch
          682 kB
          Ashutosh Chauhan
        4. HIVE-12968.4.patch
          718 kB
          Ashutosh Chauhan
        5. HIVE-12968.5.patch
          933 kB
          Ashutosh Chauhan
        6. HIVE-12968.6.patch
          968 kB
          Ashutosh Chauhan
        7. HIVE-12968.7.patch
          1010 kB
          Ashutosh Chauhan

        Issue Links

          relates 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
          requires

          New Feature - A new feature of the product, which has yet to be developed. HIVE-11398 Parse wide OR and wide AND trees to flat OR/AND trees

          • Major - Major loss of function.
          • Resolved

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: