[ https://issues.apache.org/jira/browse/CALCITE-3890?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17081110#comment-17081110 ]
Chunwei Lei commented on CALCITE-3890: -------------------------------------- [~vgarg], [~kgyrtkirk] Instead of using a rule to add ISNOTNULL predicate which is the way in Hive, I am wondering if we can do it when creating the JOIN operator. Maybe we can add a configuration to indicate whether to add ISNOTNULL predicate when creating the JOIN operator using RelBuilder. > Infer IS NOT NULL predicate from join > ------------------------------------- > > Key: CALCITE-3890 > URL: https://issues.apache.org/jira/browse/CALCITE-3890 > Project: Calcite > Issue Type: Improvement > Components: core > Reporter: Chunwei Lei > Assignee: Vineet Garg > Priority: Major > > We can infer IS NOT NULL predicate from join which implies some columns may > not be null. For instance, > > {code:java} > select * from a join b on a.id = b.id; > {code} > we can infer a.id is not null and b.id is not null. -- This message was sent by Atlassian Jira (v8.3.4#803005)