[jira] [Commented] (CALCITE-5740) Support for AggToSemiJoinRule

2023-06-18 Thread Rong Rong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5740?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17733935#comment-17733935 ] Rong Rong commented on CALCITE-5740: sounds good. filed CALCITE-5787 for

[jira] [Commented] (CALCITE-5740) Support for AggToSemiJoinRule

2023-06-16 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5740?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17733603#comment-17733603 ] Julian Hyde commented on CALCITE-5740: -- I think {{getInputFieldsUsed}} would be more useful on

[jira] [Commented] (CALCITE-5740) Support for AggToSemiJoinRule

2023-06-14 Thread Rong Rong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5740?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17732811#comment-17732811 ] Rong Rong commented on CALCITE-5740: actually i think it would be super useful to add the

[jira] [Commented] (CALCITE-5740) Support for AggToSemiJoinRule

2023-06-13 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5740?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17732263#comment-17732263 ] Julian Hyde commented on CALCITE-5740: -- Ha! Well done finding {{getAllFields}} and {{bits}}. Yes,

[jira] [Commented] (CALCITE-5740) Support for AggToSemiJoinRule

2023-06-11 Thread Rong Rong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5740?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17731376#comment-17731376 ] Rong Rong commented on CALCITE-5740: [~libenchao] i dont have a generic mechanism in mind. but the

[jira] [Commented] (CALCITE-5740) Support for AggToSemiJoinRule

2023-06-10 Thread Benchao Li (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5740?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17731212#comment-17731212 ] Benchao Li commented on CALCITE-5740: - [~rongr] I agree that your last case can be improved, by

[jira] [Commented] (CALCITE-5740) Support for AggToSemiJoinRule

2023-06-07 Thread Rong Rong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5740?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17730328#comment-17730328 ] Rong Rong commented on CALCITE-5740: i see, yeah that was a poorly chosen example. you are correct

[jira] [Commented] (CALCITE-5740) Support for AggToSemiJoinRule

2023-06-03 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5740?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17728993#comment-17728993 ] Julian Hyde commented on CALCITE-5740: -- Your example makes things clearer. I see how the Aggregate

[jira] [Commented] (CALCITE-5740) Support for AggToSemiJoinRule

2023-06-02 Thread Rong Rong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5740?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17728894#comment-17728894 ] Rong Rong commented on CALCITE-5740: forgot to post an example As an example: ``` SELECT a.col,

[jira] [Commented] (CALCITE-5740) Support for AggToSemiJoinRule

2023-06-02 Thread Rong Rong (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5740?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17728893#comment-17728893 ] Rong Rong commented on CALCITE-5740: hmm. IIUC the PROJECT_TO_SEMI_JOIN doesn't actually touches

[jira] [Commented] (CALCITE-5740) Support for AggToSemiJoinRule

2023-06-02 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5740?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17728600#comment-17728600 ] Julian Hyde commented on CALCITE-5740: -- I don’t understand. When does it make sense to convert an