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)