[jira] [Updated] (CALCITE-3920) Improve ORDER BY computation in Enumerable convention by exploiting LIMIT

2020-04-13 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3920?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis updated CALCITE-3920: - Description: There are many use-cases (pagination, top-k) relying on queries wi

[jira] [Updated] (CALCITE-3920) Improve ORDER BY computation in Enumerable convention by exploiting LIMIT

2020-04-13 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3920?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis updated CALCITE-3920: - Description: There are many use-cases (pagination, top-k) relying on queries wi

[jira] [Created] (CALCITE-3920) Improve ORDER BY computation in Enumerable convention by exploiting LIMIT

2020-04-13 Thread Stamatis Zampetakis (Jira)
Stamatis Zampetakis created CALCITE-3920: Summary: Improve ORDER BY computation in Enumerable convention by exploiting LIMIT Key: CALCITE-3920 URL: https://issues.apache.org/jira/browse/CALCITE-3920

[jira] [Commented] (CALCITE-3920) Improve ORDER BY computation in Enumerable convention by exploiting LIMIT

2020-04-13 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3920?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17082393#comment-17082393 ] Haisheng Yuan commented on CALCITE-3920: Maybe we don't have to implement them

[jira] [Commented] (CALCITE-3920) Improve ORDER BY computation in Enumerable convention by exploiting LIMIT

2020-04-13 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3920?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17082397#comment-17082397 ] Haisheng Yuan commented on CALCITE-3920: Well, given that Enumerable is in-memo

[jira] [Commented] (CALCITE-3920) Improve ORDER BY computation in Enumerable convention by exploiting LIMIT

2020-04-13 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3920?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17082493#comment-17082493 ] Stamatis Zampetakis commented on CALCITE-3920: -- Totally, I am thinking som

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

2020-04-13 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3917?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17082629#comment-17082629 ] Stamatis Zampetakis commented on CALCITE-3917: -- I'm totally with you on th

[jira] [Resolved] (CALCITE-3576) Remove Enumerable convention check in FilterIntoJoinRule

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

[jira] [Resolved] (CALCITE-3909) RelMdMinRowCount doesn't take into account UNION DISTINCT

2020-04-13 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3909?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei resolved CALCITE-3909. -- Fix Version/s: 1.23.0 Resolution: Fixed Fixed in  [https://github.com/apache/calcite/c

[jira] [Commented] (CALCITE-3733) In JDBC adapter, when generating SQL for MYSQL, generate TIMESTAMP type as DATETIME for CAST

2020-04-13 Thread Feng Zhu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3733?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17082792#comment-17082792 ] Feng Zhu commented on CALCITE-3733: --- Fixed in [https://github.com/apache/calcite/com

[jira] [Resolved] (CALCITE-3733) In JDBC adapter, when generating SQL for MYSQL, generate TIMESTAMP type as DATETIME for CAST

2020-04-13 Thread Feng Zhu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3733?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Feng Zhu resolved CALCITE-3733. --- Fix Version/s: 1.23.0 Resolution: Fixed > In JDBC adapter, when generating SQL for MYSQL, ge

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

2020-04-13 Thread Wang Yanlin (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3919?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17082795#comment-17082795 ] Wang Yanlin commented on CALCITE-3919: -- Hi, [~Chunwei Lei] , I'm currently working

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

2020-04-13 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3917?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17082797#comment-17082797 ] Danny Chen commented on CALCITE-3917: - This reminds me of the SQL hint such as NO_H

[jira] [Updated] (CALCITE-3737) HOP Table-valued Function

2020-04-13 Thread Feng Zhu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3737?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Feng Zhu updated CALCITE-3737: -- Fix Version/s: 1.23.0 > HOP Table-valued Function > - > > Key

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

2020-04-13 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3917?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17082802#comment-17082802 ] Haisheng Yuan commented on CALCITE-3917: [~danny0405] Your problem is easy to f

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

2020-04-13 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3917?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17082807#comment-17082807 ] Danny Chen commented on CALCITE-3917: - If we can tweak the cost for HASH_JOIN for N

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

2020-04-13 Thread Xiening Dai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3917?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17082810#comment-17082810 ] Xiening Dai commented on CALCITE-3917: -- We can't because the penalty doesn't preve

[jira] [Comment Edited] (CALCITE-3896) Pass through parent trait requests to child operators

2020-04-13 Thread Jinpeng Wu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17077812#comment-17077812 ] Jinpeng Wu edited comment on CALCITE-3896 at 4/14/20, 6:02 AM: --

[jira] [Commented] (CALCITE-3896) Pass through parent trait requests to child operators

2020-04-13 Thread Jinpeng Wu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17082903#comment-17082903 ] Jinpeng Wu commented on CALCITE-3896: - Hi，[~hyuan] 。 # Got it # For example, some