[jira] [Commented] (CALCITE-2857) SemiJoin extends Join directly instead of EquiJoin to support non-equi condition

2019-05-29 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2857?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16851302#comment-16851302 ] Julian Hyde commented on CALCITE-2857: -- [~rubenql] Please create JIRA links. Then we can navigate

[jira] [Commented] (CALCITE-2857) SemiJoin extends Join directly instead of EquiJoin to support non-equi condition

2019-04-05 Thread Ruben Quesada Lopez (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2857?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16810979#comment-16810979 ] Ruben Quesada Lopez commented on CALCITE-2857: -- Please be aware that there is another,

[jira] [Commented] (CALCITE-2857) SemiJoin extends Join directly instead of EquiJoin to support non-equi condition

2019-03-12 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2857?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16790910#comment-16790910 ] Haisheng Yuan commented on CALCITE-2857: I have the same question with [~vgarg] that why can't

[jira] [Commented] (CALCITE-2857) SemiJoin extends Join directly instead of EquiJoin to support non-equi condition

2019-03-11 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2857?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16790255#comment-16790255 ] Vineet Garg commented on CALCITE-2857: -- {quote}You're probably right. So, would we split into

[jira] [Commented] (CALCITE-2857) SemiJoin extends Join directly instead of EquiJoin to support non-equi condition

2019-03-11 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2857?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16790152#comment-16790152 ] Haisheng Yuan commented on CALCITE-2857: A simpler repro query would be: {code:sql} select *

[jira] [Commented] (CALCITE-2857) SemiJoin extends Join directly instead of EquiJoin to support non-equi condition

2019-03-11 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2857?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16790064#comment-16790064 ] Haisheng Yuan commented on CALCITE-2857: Cancel my previous comment. In that case, SemiJoin

[jira] [Commented] (CALCITE-2857) SemiJoin extends Join directly instead of EquiJoin to support non-equi condition

2019-03-11 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2857?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16790060#comment-16790060 ] Haisheng Yuan commented on CALCITE-2857: Is it possible to add a join filter to current

[jira] [Commented] (CALCITE-2857) SemiJoin extends Join directly instead of EquiJoin to support non-equi condition

2019-03-11 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2857?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16790054#comment-16790054 ] Julian Hyde commented on CALCITE-2857: -- No. Because SemiJoin only returns columns from one side.

[jira] [Commented] (CALCITE-2857) SemiJoin extends Join directly instead of EquiJoin to support non-equi condition

2019-03-11 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2857?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16790057#comment-16790057 ] Haisheng Yuan commented on CALCITE-2857: Ah, right. My mistake. > SemiJoin extends Join

[jira] [Commented] (CALCITE-2857) SemiJoin extends Join directly instead of EquiJoin to support non-equi condition

2019-03-11 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2857?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16790053#comment-16790053 ] Haisheng Yuan commented on CALCITE-2857: Can we add a filter (emp.job > dept.name) on top of

[jira] [Commented] (CALCITE-2857) SemiJoin extends Join directly instead of EquiJoin to support non-equi condition

2019-03-11 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2857?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16790001#comment-16790001 ] Julian Hyde commented on CALCITE-2857: -- You're probably right. So, would we split into SemiJoin

[jira] [Commented] (CALCITE-2857) SemiJoin extends Join directly instead of EquiJoin to support non-equi condition

2019-03-07 Thread Vineet Garg (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2857?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16787523#comment-16787523 ] Vineet Garg commented on CALCITE-2857: -- bq. Agree, either IN or NOT IN, a.k.a semi-join and

[jira] [Commented] (CALCITE-2857) SemiJoin extends Join directly instead of EquiJoin to support non-equi condition

2019-03-07 Thread Kevin Risden (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2857?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16786784#comment-16786784 ] Kevin Risden commented on CALCITE-2857: --- Removed the fix version since there is no PR and will

[jira] [Commented] (CALCITE-2857) SemiJoin extends Join directly instead of EquiJoin to support non-equi condition

2019-03-01 Thread Haisheng Yuan (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2857?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16782229#comment-16782229 ] Haisheng Yuan commented on CALCITE-2857: Agree, either IN or NOT IN, a.k.a semi-join and

[jira] [Commented] (CALCITE-2857) SemiJoin extends Join directly instead of EquiJoin to support non-equi condition

2019-02-21 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2857?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16774670#comment-16774670 ] Julian Hyde commented on CALCITE-2857: -- Oops. I mis-spoke. I guess there is an anti-semi-join

[jira] [Commented] (CALCITE-2857) SemiJoin extends Join directly instead of EquiJoin to support non-equi condition

2019-02-21 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2857?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16774666#comment-16774666 ] Julian Hyde commented on CALCITE-2857: -- Semi-join is not always an equi-join. So, if we move it