[jira] [Created] (HIVE-12968) genNotNullFilterForJoinSourcePlan: needs to merge predicates into the multi-AND

[Gopal V (JIRA)]

Gopal V created HIVE-12968:
------------------------------

             Summary: genNotNullFilterForJoinSourcePlan: needs to merge 
predicates into the multi-AND
                 Key: HIVE-12968
                 URL: https://issues.apache.org/jira/browse/HIVE-12968
             Project: Hive
          Issue Type: Improvement
          Components: Logical Optimizer
    Affects Versions: 2.1.0
            Reporter: Gopal V
            Priority: Minor


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

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

For example, see {{tez_dynpart_hashjoin_1.q}}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)