[jira] [Commented] (CALCITE-1495) Add a rule to convert INNER JOIN preceded by GROUP BY to appropriate SEMI-JOIN

[ https://issues.apache.org/jira/browse/CALCITE-1495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15713199#comment-15713199 ] Julian Hyde commented on CALCITE-1495: -- Changing the subject to refer to the incorrect behavior

[jira] [Commented] (CALCITE-1495) Add a rule to convert INNER JOIN preceded by GROUP BY to appropriate SEMI-JOIN

[ https://issues.apache.org/jira/browse/CALCITE-1495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15710998#comment-15710998 ] Ashutosh Chauhan commented on CALCITE-1495: --- [~julianhyde] Until enhancement you suggested is

[jira] [Commented] (CALCITE-1495) Add a rule to convert INNER JOIN preceded by GROUP BY to appropriate SEMI-JOIN

[ https://issues.apache.org/jira/browse/CALCITE-1495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15671284#comment-15671284 ] Vineet Garg commented on CALCITE-1495: -- Sounds good. Thank for the help > Add a rule to convert

[jira] [Commented] (CALCITE-1495) Add a rule to convert INNER JOIN preceded by GROUP BY to appropriate SEMI-JOIN

[ https://issues.apache.org/jira/browse/CALCITE-1495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15671268#comment-15671268 ] Julian Hyde commented on CALCITE-1495: -- Maybe... but I think you should try the existing rule in

[jira] [Commented] (CALCITE-1495) Add a rule to convert INNER JOIN preceded by GROUP BY to appropriate SEMI-JOIN

[ https://issues.apache.org/jira/browse/CALCITE-1495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15671230#comment-15671230 ] Vineet Garg commented on CALCITE-1495: -- Thanks Julian. I think HIVE can use this existing rule.

[jira] [Commented] (CALCITE-1495) Add a rule to convert INNER JOIN preceded by GROUP BY to appropriate SEMI-JOIN

[ https://issues.apache.org/jira/browse/CALCITE-1495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15670991#comment-15670991 ] Julian Hyde commented on CALCITE-1495: -- Yes, {{SemiJoinRule}} ensures that no columns from the RHS

[jira] [Commented] (CALCITE-1495) Add a rule to convert INNER JOIN preceded by GROUP BY to appropriate SEMI-JOIN

[ https://issues.apache.org/jira/browse/CALCITE-1495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15669174#comment-15669174 ] Julian Hyde commented on CALCITE-1495: -- You can have a *physical* semi-join operator without having

[jira] [Commented] (CALCITE-1495) Add a rule to convert INNER JOIN preceded by GROUP BY to appropriate SEMI-JOIN

[ https://issues.apache.org/jira/browse/CALCITE-1495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15668955#comment-15668955 ] Vineet Garg commented on CALCITE-1495: -- Thanks Julian. I did not know that Calcite already has a

[jira] [Commented] (CALCITE-1495) Add a rule to convert INNER JOIN preceded by GROUP BY to appropriate SEMI-JOIN

[ https://issues.apache.org/jira/browse/CALCITE-1495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15668863#comment-15668863 ] Julian Hyde commented on CALCITE-1495: -- We already have SemiJoinRule. I'm a bit skeptical about