[ https://issues.apache.org/jira/browse/CALCITE-1909?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16115598#comment-16115598 ]
Zhiqiang He edited comment on CALCITE-1909 at 8/6/17 2:59 AM: -------------------------------------------------------------- [~julianhyde] please review it , thanks. https://github.com/apache/calcite/pull/508 was (Author: ransom): please review it , thanks. https://github.com/apache/calcite/pull/508 > The output rowType should also include partition by and order by key columns > ---------------------------------------------------------------------------- > > Key: CALCITE-1909 > URL: https://issues.apache.org/jira/browse/CALCITE-1909 > Project: Calcite > Issue Type: Bug > Reporter: Dian Fu > Assignee: Zhiqiang He > Labels: match > > According to the documentation, the output rowType should also include > partition by key columns and order by key columns. > {quote} > MATCH_RECOGNIZE is called the row pattern output table. The shape (row type) > of the row pattern output table depends on the choice of ONE ROW PER MATCH or > ALL ROWS PER MATCH: > * If ONE ROW PER MATCH is specied or implied, then the columns of the row > pattern output table are the row pattern partitioning columns in their order > of declaration, followed by the row pattern measure columns in their order of > declaration. Since a table must have at least one column, this implies that > there must be at least one row pattern partitioning column or one row pattern > measure column. > * If ALL ROWS PER MATCH is speci ed, then the columns of the row pattern > output table are the row pattern partitioning columns in their order of > declaration, the ordering columns in their order of declaration, the row > pattern measure columns in their order of declaration, and nally any > remaining columns of the row pattern input table, in the order they occur in > the row pattern input table. > {quote} > Currently, partition key columns and order by key columns are not included in > the output row type. -- This message was sent by Atlassian JIRA (v6.4.14#64029)