[jira] [Commented] (CALCITE-3890) Infer IS NOT NULL predicate from join

2022-05-09 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3890?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17534097#comment-17534097 ] Chunwei Lei commented on CALCITE-3890: -- I opened a PR for this feature:

[jira] [Commented] (CALCITE-3890) Infer IS NOT NULL predicate from join

2022-04-23 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3890?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17526960#comment-17526960 ] Chunwei Lei commented on CALCITE-3890: -- [~vgarg] any progress on this work? I would like to help

[jira] [Commented] (CALCITE-3890) Infer IS NOT NULL predicate from join

2020-04-10 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3890?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17081169#comment-17081169 ] Julian Hyde commented on CALCITE-3890: -- I'm worried about adding a configuration parameter. We

[jira] [Commented] (CALCITE-3890) Infer IS NOT NULL predicate from join

2020-04-10 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3890?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17081110#comment-17081110 ] Chunwei Lei commented on CALCITE-3890: -- [~vgarg], [~kgyrtkirk] Instead of using a rule to add

[jira] [Commented] (CALCITE-3890) Infer IS NOT NULL predicate from join

2020-04-01 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3890?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17073323#comment-17073323 ] Chunwei Lei commented on CALCITE-3890: -- [~vgarg], welcome to contribute. I assigned the issue to

[jira] [Commented] (CALCITE-3890) Infer IS NOT NULL predicate from join

2020-04-01 Thread Vineet Garg (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3890?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17073268#comment-17073268 ] Vineet Garg commented on CALCITE-3890: -- As [~kgyrtkirk] pointed out we have doing this in Hive for

[jira] [Commented] (CALCITE-3890) Infer IS NOT NULL predicate from join

2020-04-01 Thread Zoltan Haindrich (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3890?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17072624#comment-17072624 ] Zoltan Haindrich commented on CALCITE-3890: --- [~Chunwei Lei]: in Hive we have a rule which

[jira] [Commented] (CALCITE-3890) Infer IS NOT NULL predicate from join

2020-03-31 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3890?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17072391#comment-17072391 ] Julian Hyde commented on CALCITE-3890: -- I agree. And we can also push down filters: ‘id is not