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.7.patch
          1010 kB
          Ashutosh Chauhan
        2. HIVE-12968.6.patch
          968 kB
          Ashutosh Chauhan
        3. HIVE-12968.5.patch
          933 kB
          Ashutosh Chauhan
        4. HIVE-12968.4.patch
          718 kB
          Ashutosh Chauhan
        5. HIVE-12968.3.patch
          682 kB
          Ashutosh Chauhan
        6. HIVE-12968.2.patch
          653 kB
          Gopal Vijayaraghavan
        7. HIVE-12968.1.patch
          10 kB
          Gopal Vijayaraghavan

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: