[jira] [Commented] (CALCITE-1945) Allow custom return types for AVG/VARIANCE/STDDEV/COVAR

2017-08-15 Thread MinJi Kim (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1945?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16128197#comment-16128197 ] MinJi Kim commented on CALCITE-1945: I have a first draft of this patch here. I would like to make

[jira] [Comment Edited] (CALCITE-1897) Support operator "%" as an alternative to "mod"

2017-08-15 Thread sunjincheng (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1897?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16126679#comment-16126679 ] sunjincheng edited comment on CALCITE-1897 at 8/15/17 10:44 PM: Ah,

[jira] [Commented] (CALCITE-1944) Wrong plan for query with window functions and subquery with star

2017-08-15 Thread Volodymyr Vysotskyi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1944?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16127630#comment-16127630 ] Volodymyr Vysotskyi commented on CALCITE-1944: -- I have created a pull request

[jira] [Created] (CALCITE-1944) Wrong plan for query with window functions and subquery with star

2017-08-15 Thread Volodymyr Vysotskyi (JIRA)
Volodymyr Vysotskyi created CALCITE-1944: Summary: Wrong plan for query with window functions and subquery with star Key: CALCITE-1944 URL: https://issues.apache.org/jira/browse/CALCITE-1944

[jira] [Commented] (CALCITE-1903) Support charset in LIKE expression

2017-08-15 Thread Jark Wu (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1903?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16127221#comment-16127221 ] Jark Wu commented on CALCITE-1903: -- Hi [~julianhyde] , if this is not allowed, how to use an unicode

[jira] [Commented] (CALCITE-1924) Support operator "+" as string concat operator

2017-08-15 Thread Roger Shi (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1924?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16127171#comment-16127171 ] Roger Shi commented on CALCITE-1924: [~julianhyde], I find it's hard or impossible to tell whether

[jira] [Commented] (CALCITE-1935) Reference implementation for MATCH_RECOGNIZE

2017-08-15 Thread Zhiqiang He (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1935?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16127129#comment-16127129 ] Zhiqiang He commented on CALCITE-1935: -- But regular expression can not conver all functions in

[jira] [Commented] (CALCITE-1943) Add back NavigationExpander and NavigationReplacer in SqlValidatorImpl

2017-08-15 Thread Dian Fu (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1943?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16127038#comment-16127038 ] Dian Fu commented on CALCITE-1943: -- In one word, if we don't transform {{A.net_weight}} to

[jira] [Commented] (CALCITE-1943) Add back NavigationExpander and NavigationReplacer in SqlValidatorImpl

2017-08-15 Thread Dian Fu (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1943?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16127023#comment-16127023 ] Dian Fu commented on CALCITE-1943: -- You're right. This is related to how to implement the above

[jira] [Commented] (CALCITE-1935) Reference implementation for MATCH_RECOGNIZE

2017-08-15 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1935?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16127022#comment-16127022 ] Julian Hyde commented on CALCITE-1935: -- As you have said, building an NFA is expensive. It might be

[jira] [Commented] (CALCITE-1943) Add back NavigationExpander and NavigationReplacer in SqlValidatorImpl

2017-08-15 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1943?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16127009#comment-16127009 ] Julian Hyde commented on CALCITE-1943: -- I get the sense that you have had design discussions in

[jira] [Commented] (CALCITE-1943) Add back NavigationExpander and NavigationReplacer in SqlValidatorImpl

2017-08-15 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1943?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16127003#comment-16127003 ] Julian Hyde commented on CALCITE-1943: -- Why is {{PREV("A"."net_weight", 0)}} better than

[jira] [Commented] (CALCITE-1943) Add back NavigationExpander and NavigationReplacer in SqlValidatorImpl

2017-08-15 Thread Dian Fu (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1943?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16126989#comment-16126989 ] Dian Fu commented on CALCITE-1943: -- I have created a PR: https://github.com/apache/calcite/pull/516

[jira] [Commented] (CALCITE-1871) Nesting LAST within PREV is not parsed correctly for MATCH_RECOGNIZE

2017-08-15 Thread Dian Fu (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1871?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16126887#comment-16126887 ] Dian Fu commented on CALCITE-1871: -- Hi [~ransom], thanks for your reply. I have created an issue

[jira] [Commented] (CALCITE-1943) Add back NavigationExpander and NavigationReplacer in SqlValidatorImpl

2017-08-15 Thread Dian Fu (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1943?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16126885#comment-16126885 ] Dian Fu commented on CALCITE-1943: -- For {{NavigationExpander}}, currently I have not got a quite

[jira] [Created] (CALCITE-1943) Add back NavigationExpander and NavigationReplacer in SqlValidatorImpl

2017-08-15 Thread Dian Fu (JIRA)
Dian Fu created CALCITE-1943: Summary: Add back NavigationExpander and NavigationReplacer in SqlValidatorImpl Key: CALCITE-1943 URL: https://issues.apache.org/jira/browse/CALCITE-1943 Project: Calcite

[jira] [Commented] (CALCITE-1871) Nesting LAST within PREV is not parsed correctly for MATCH_RECOGNIZE

2017-08-15 Thread Zhiqiang He (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1871?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16126868#comment-16126868 ] Zhiqiang He commented on CALCITE-1871: -- [~dian.fu] No, It would not add back in future. It was

[jira] [Commented] (CALCITE-1871) Nesting LAST within PREV is not parsed correctly for MATCH_RECOGNIZE

2017-08-15 Thread Dian Fu (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-1871?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16126861#comment-16126861 ] Dian Fu commented on CALCITE-1871: -- Hi [~ransom], just found that this patch disabled