[jira] [Comment Edited] (CALCITE-3919) Upgrade ProjectJoinTransposeRule to allow user choose whether to keep join condition

2020-04-12 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3919?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17082069#comment-17082069 ] Chunwei Lei edited comment on CALCITE-3919 at 4/13/20, 5:19 AM: I don't

[jira] [Commented] (CALCITE-3919) Upgrade ProjectJoinTransposeRule to allow user choose whether to keep join condition

2020-04-12 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3919?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17082069#comment-17082069 ] Chunwei Lei commented on CALCITE-3919: -- I don't think it is a bug. The condition seems useless if 

[jira] [Assigned] (CALCITE-3910) Enhance ProjectJoinTransposeRule to support SemiJoin and AntiJoin

2020-04-12 Thread Liya Fan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3910?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Liya Fan reassigned CALCITE-3910: - Assignee: Liya Fan > Enhance ProjectJoinTransposeRule to support SemiJoin and AntiJoin >

[jira] [Commented] (CALCITE-3910) Enhance ProjectJoinTransposeRule to support SemiJoin and AntiJoin

2020-04-12 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3910?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17082017#comment-17082017 ] Chunwei Lei commented on CALCITE-3910: -- [~fan_li_ya] , go ahead. > Enhance

[jira] [Commented] (CALCITE-3910) Enhance ProjectJoinTransposeRule to support SemiJoin and AntiJoin

2020-04-12 Thread Liya Fan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3910?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17082012#comment-17082012 ] Liya Fan commented on CALCITE-3910: --- [~Chunwei Lei] Thanks for opening this issue. It looks

[jira] [Commented] (CALCITE-3910) Enhance ProjectJoinTransposeRule to support SemiJoin and AntiJoin

2020-04-12 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3910?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17082011#comment-17082011 ] Chunwei Lei commented on CALCITE-3910: -- [~zabetak] , no, I am not working on this. > Enhance

[jira] [Commented] (CALCITE-2593) Sometimes fails to plan when a RelNode transform multiple collations to single collation

2020-04-12 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17081984#comment-17081984 ] Haisheng Yuan commented on CALCITE-2593: The most fundamental change is dropping

[jira] [Commented] (CALCITE-3893) SQL with GROUP_ID may generate wrong plan

2020-04-12 Thread Feng Zhu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3893?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17081981#comment-17081981 ] Feng Zhu commented on CALCITE-3893: --- Ok, thanks for your feedback. I'd like to make a final

[jira] [Commented] (CALCITE-2010) Cannot plan query that is UNION ALL applied to VALUES

2020-04-12 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2010?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17081960#comment-17081960 ] Haisheng Yuan commented on CALCITE-2010: Opened PR to fix the underlying issue:

[jira] [Resolved] (CALCITE-2010) Cannot plan query that is UNION ALL applied to VALUES

2020-04-12 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2010?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-2010. Fix Version/s: 1.23.0 Resolution: Fixed Fixed in

[jira] [Resolved] (CALCITE-3865) RelCollationTraitDef.canConvert should always return true

2020-04-12 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3865?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3865. Fix Version/s: 1.23.0 Resolution: Fixed Fixed in

[jira] [Resolved] (CALCITE-2593) Sometimes fails to plan when a RelNode transform multiple collations to single collation

2020-04-12 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2593?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-2593. Fix Version/s: 1.23.0 Resolution: Fixed Fixed in

[jira] [Resolved] (CALCITE-2592) EnumerableMergeJoin is never taken

2020-04-12 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2592?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-2592. Fix Version/s: 1.23.0 Resolution: Fixed Fixed in

[jira] [Resolved] (CALCITE-3914) Improve SubstitutionVisitor to consider RexCall of type PLUS and TIMES for canonicalization

2020-04-12 Thread Jesus Camacho Rodriguez (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3914?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jesus Camacho Rodriguez resolved CALCITE-3914. -- Fix Version/s: 1.23.0 Resolution: Fixed Fixed in

[jira] [Updated] (CALCITE-3889) Add apply(Mappings.Mapping) to RelTrait and RelTraitSet

2020-04-12 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3889?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3889: Labels: pull-request-available (was: ) > Add apply(Mappings.Mapping) to RelTrait and

[jira] [Commented] (CALCITE-3916) Apply rules bottom up by RelSet

2020-04-12 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3916?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17081837#comment-17081837 ] Haisheng Yuan commented on CALCITE-3916: No matter before removing importance from subset or

[jira] [Comment Edited] (CALCITE-3916) Apply rules bottom up by RelSet

2020-04-12 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3916?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17081819#comment-17081819 ] Haisheng Yuan edited comment on CALCITE-3916 at 4/12/20, 2:39 PM: -- Hi

[jira] [Commented] (CALCITE-3916) Apply rules bottom up by RelSet

2020-04-12 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3916?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17081819#comment-17081819 ] Haisheng Yuan commented on CALCITE-3916: Hi [~zabetak], I understand that it might be a little

[jira] [Commented] (CALCITE-3917) Revive pruned node when a rule generates RelNode that is already pruned

2020-04-12 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3917?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17081803#comment-17081803 ] Haisheng Yuan commented on CALCITE-3917: That is why many optimizers use walking through the

[jira] [Commented] (CALCITE-3917) Revive pruned node when a rule generates RelNode that is already pruned

2020-04-12 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3917?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17081802#comment-17081802 ] Haisheng Yuan commented on CALCITE-3917: Yes, I agree. > Revive pruned node when a rule

[jira] [Commented] (CALCITE-3910) Enhance ProjectJoinTransposeRule to support SemiJoin and AntiJoin

2020-04-12 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3910?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17081801#comment-17081801 ] Stamatis Zampetakis commented on CALCITE-3910: -- Are you working on this [~Chunwei Lei]? Is

[jira] [Commented] (CALCITE-3915) Add rule listener to report rule attempts and time at DEBUG log level

2020-04-12 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3915?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17081799#comment-17081799 ] Stamatis Zampetakis commented on CALCITE-3915: -- Indeed sounds useful, didn't yet check the

[jira] [Commented] (CALCITE-3919) Upgrade ProjectJoinTransposeRule to allow user choose whether to keep join condition

2020-04-12 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3919?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17081796#comment-17081796 ] Stamatis Zampetakis commented on CALCITE-3919: -- The fact that {{ProjectJoinTransposeRule}}

[jira] [Commented] (CALCITE-3917) Revive pruned node when a rule generates RelNode that is already pruned

2020-04-12 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3917?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17081792#comment-17081792 ] Stamatis Zampetakis commented on CALCITE-3917: -- This shows again that manual pruning is

[jira] [Commented] (CALCITE-3916) Apply rules bottom up by RelSet

2020-04-12 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3916?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17081790#comment-17081790 ] Stamatis Zampetakis commented on CALCITE-3916: -- Hi [~hyuan], before removing the

[jira] [Assigned] (CALCITE-3919) Upgrade ProjectJoinTransposeRule to allow user choose whether to keep join condition

2020-04-12 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3919?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin reassigned CALCITE-3919: Assignee: Wang Yanlin > Upgrade ProjectJoinTransposeRule to allow user choose whether

[jira] [Updated] (CALCITE-3919) Upgrade ProjectJoinTransposeRule to allow user choose whether to keep join condition

2020-04-12 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3919?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3919: Labels: pull-request-available (was: ) > Upgrade ProjectJoinTransposeRule to allow user

[jira] [Updated] (CALCITE-3919) Upgrade ProjectJoinTransposeRule to allow user choose whether to keep join condition

2020-04-12 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3919?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin updated CALCITE-3919: - Description: Currently, when apply ProjectJoinTransposeRule, the join condition may be also

[jira] [Updated] (CALCITE-3919) Upgrade ProjectJoinTransposeRule to allow user choose whether to keep join condition

2020-04-12 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3919?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin updated CALCITE-3919: - Description: Currently, when apply ProjectJoinTransposeRule, the join condition may be also

[jira] [Updated] (CALCITE-3919) Upgrade ProjectJoinTransposeRule to allow user choose whether to keep join condition

2020-04-12 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3919?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wang Yanlin updated CALCITE-3919: - Summary: Upgrade ProjectJoinTransposeRule to allow user choose whether to keep join condition

[jira] [Created] (CALCITE-3919) Improve ProjectJoinTransposeRule to allow user choose whether to keep join filter

2020-04-12 Thread Wang Yanlin (Jira)
Wang Yanlin created CALCITE-3919: Summary: Improve ProjectJoinTransposeRule to allow user choose whether to keep join filter Key: CALCITE-3919 URL: https://issues.apache.org/jira/browse/CALCITE-3919