Zoltan Haindrich created HIVE-20689:
---------------------------------------

             Summary: Simplifying using predicates should consider not equals 
in case its a predicate
                 Key: HIVE-20689
                 URL: https://issues.apache.org/jira/browse/HIVE-20689
             Project: Hive
          Issue Type: Bug
            Reporter: Zoltan Haindrich
            Assignee: Zoltan Haindrich


Right now simplifyUsingPredicates bails out for [all <> 
comparisions|https://github.com/apache/calcite/blob/c39bfaa02a06ac91575076a6e74f29863923f5eb/core/src/main/java/org/apache/calcite/rex/RexSimplify.java#L1050];
 however if it's already an explicit predicate (or its negated one); then it 
could be demoted to:
{code}
x IS NOT NULL or null
{code}
which could be further simplified in most cases..




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to