[
https://issues.apache.org/jira/browse/CALCITE-1540?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15761317#comment-15761317
]
hongbin ma commented on CALCITE-1540:
-------------------------------------
sorry my previous question might be confusing. I DO know how to configure
different code style for different projects. What I'm asking for is something
like http://hbase.apache.org/0.94/book/ides.html, which shows how to config the
right FORMATTER for the project with a simple XML:hbase_eclipse_formatter.xml.
Calcite seem not to have such thing, so I cannot conveniently configure the
IDE's Code Formatter.
Calcite even has some customized check style rules, like
HydromaticFileSetCheck, which makes it hard to configure checkstyle IDE
plugins(check its related issue
https://issues.apache.org/jira/browse/CALCITE-1127).
With above situations, I have to laboriously repeat running "mvn clean install
-DskipTests" and refine the my codes according to the outputs. Can you share
your experience on this?
> Support multiple columns in PARTITION BY clause of window function
> ------------------------------------------------------------------
>
> Key: CALCITE-1540
> URL: https://issues.apache.org/jira/browse/CALCITE-1540
> Project: Calcite
> Issue Type: Bug
> Affects Versions: 1.10.0
> Reporter: hongbin ma
> Assignee: Julian Hyde
> Fix For: 1.11.0
>
> Attachments:
> 0001-CALCITE-1540-window-function-does-not-support-multip-2.patch,
> 0001-CALCITE-1540-window-function-does-not-support-multip.patch
>
>
> When I add multiple partition columns to a window function:
> {code:xml}
> @Test public void testSelect() throws SQLException {
> checkSql("model", "select NAME,DEPTNO,count(*) over (partition by
> NAME,DEPTNO) from EMPS");
> }
> {code}
> Following exception is thrown:
> {noformat}
> java.sql.SQLException: Error while executing SQL "select NAME,DEPTNO,count(*)
> over (partition by NAME,DEPTNO) from EMPS": Error while compiling generated
> Java code:
> {noformat}
> However the document from calcite.apache.org/docs/reference.html states
> multiple partition columns should be allowed:
> {code}
> windowSpec:
> [ windowName ]
> '('
> [ ORDER BY orderItem [, orderItem ]* ]
> [ PARTITION BY expression [, expression ]* ]
> [
> RANGE numericOrIntervalExpression { PRECEDING | FOLLOWING }
> | ROWS numericExpression { PRECEDING | FOLLOWING }
> ]
> ')'
> {code}
> After searching it seems no one is reporting the same issue. I'm opening this
> JIAR as a placeholder, will try to fix this issue
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
