[jira] [Updated] (CALCITE-1540) Support multiple columns in PARTITION BY clause of window function

[Julian Hyde (JIRA)]

     [ 
https://issues.apache.org/jira/browse/CALCITE-1540?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Julian Hyde updated CALCITE-1540:
---------------------------------
    Description: 
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

  was:
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:

java.sql.SQLException: Error while executing SQL "select NAME,DEPTNO,count(*) 
over (partition by NAME,DEPTNO) from EMPS": Error while compiling generated 
Java code:

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


> 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: hongbin ma
>             Fix For: 1.11.0
>
>         Attachments: 
> 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)