[jira] [Commented] (CALCITE-4160) Add configuration to retain ORDER BY in sub-query

2020-09-04 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17190811#comment-17190811 ] Julian Hyde commented on CALCITE-4160: -- Thanks for fixing that, [~Aron.tao] and [~

[jira] [Commented] (CALCITE-4160) Add configuration to retain ORDER BY in sub-query

2020-09-03 Thread Jiatao Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17190492#comment-17190492 ] Jiatao Tao commented on CALCITE-4160: - Hi [~julianhyde], sorry for that, Danny had

[jira] [Commented] (CALCITE-4160) Add configuration to retain ORDER BY in sub-query

2020-09-03 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17190484#comment-17190484 ] Danny Chen commented on CALCITE-4160: - Fixed in [734a7ac|https://github.com/apache

[jira] [Commented] (CALCITE-4160) Add configuration to retain ORDER BY in sub-query

2020-09-03 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17190367#comment-17190367 ] Julian Hyde commented on CALCITE-4160: -- In Calcite we have standardized on "sub-qu

[jira] [Commented] (CALCITE-4160) Add configuration to retain ORDER BY in sub-query

2020-09-01 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17188696#comment-17188696 ] Julian Hyde commented on CALCITE-4160: -- Interesting research, [~zabetak]. But the

[jira] [Commented] (CALCITE-4160) Add configuration to retain ORDER BY in sub-query

2020-09-01 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17188274#comment-17188274 ] Danny Chen commented on CALCITE-4160: - Thanks for the share [~zabetak], what is the

[jira] [Commented] (CALCITE-4160) Add configuration to retain ORDER BY in sub-query

2020-09-01 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17188261#comment-17188261 ] Stamatis Zampetakis commented on CALCITE-4160: -- The SQL standard classifie

[jira] [Commented] (CALCITE-4160) Add configuration to retain ORDER BY in sub-query

2020-08-09 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17174094#comment-17174094 ] Danny Chen commented on CALCITE-4160: - Yes, there is global config, see {{CalciteSy

[jira] [Commented] (CALCITE-4160) Add configuration to retain ORDER BY in sub-query

2020-08-09 Thread Jiatao Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17174092#comment-17174092 ] Jiatao Tao commented on CALCITE-4160: - [~julianhyde] Got it, thanks! And In our sy

[jira] [Commented] (CALCITE-4160) Add configuration to retain ORDER BY in sub-query

2020-08-09 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17173946#comment-17173946 ] Julian Hyde commented on CALCITE-4160: -- [~Aron.tao], A note on Jira usage. Rather

[jira] [Commented] (CALCITE-4160) Add configuration to retain ORDER BY in sub-query

2020-08-09 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17173945#comment-17173945 ] Julian Hyde commented on CALCITE-4160: -- I am against a global config option becaus

[jira] [Commented] (CALCITE-4160) Add configuration to retain ORDER BY in sub-query

2020-08-08 Thread Jiatao Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17173742#comment-17173742 ] Jiatao Tao commented on CALCITE-4160: - [~julianhyde] I think hint and configuration

[jira] [Commented] (CALCITE-4160) Add configuration to retain ORDER BY in sub-query

2020-08-07 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17172995#comment-17172995 ] Julian Hyde commented on CALCITE-4160: -- [~danny0405], That may be the case. Howeve

[jira] [Commented] (CALCITE-4160) Add configuration to retain ORDER BY in sub-query

2020-08-07 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17172958#comment-17172958 ] Danny Chen commented on CALCITE-4160: - If people write that sort in sub-query, they

[jira] [Commented] (CALCITE-4160) Add configuration to retain ORDER BY in sub-query

2020-08-06 Thread Jiatao Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17172782#comment-17172782 ] Jiatao Tao commented on CALCITE-4160: - [~julianhyde], [~zabetak] SQL: val sql = "s

[jira] [Commented] (CALCITE-4160) Add configuration to retain ORDER BY in sub-query

2020-08-06 Thread Jiatao Tao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17172777#comment-17172777 ] Jiatao Tao commented on CALCITE-4160: - Hi [~zabetak], [~julianhyde] In ByteDance,

[jira] [Commented] (CALCITE-4160) Add configuration to retain ORDER BY in sub-query

2020-08-06 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17172506#comment-17172506 ] Julian Hyde commented on CALCITE-4160: -- Can you describe the "user" who needs this

[jira] [Commented] (CALCITE-4160) Add configuration to retain ORDER BY in sub-query

2020-08-06 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-4160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17172136#comment-17172136 ] Stamatis Zampetakis commented on CALCITE-4160: -- Hi [~Aron.tao] can you exp