[
https://issues.apache.org/jira/browse/FLINK-6238?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Fabian Hueske closed FLINK-6238.
--------------------------------
Resolution: Duplicate
Duplicate of FLINK-6473
> support OVER on batch SQL
> -------------------------
>
> Key: FLINK-6238
> URL: https://issues.apache.org/jira/browse/FLINK-6238
> Project: Flink
> Issue Type: New Feature
> Components: Table API & SQL
> Reporter: godfrey he
> Assignee: godfrey he
> Priority: Major
>
> The syntax of the {{OVER}} clause is:
> {code}
> <function> OVER ( [PARTITION BY clause]
> [ORDER BY clause]
> [ROWS or RANGE clause] )
> {code}
> currently, there are many limits about OVER function:
> 1. {{ROWS}} or {{RANGE}} clause only supports {{ROWS}} now.
> 2. the window frame only supports {{BETWEEN UNBOUNDED PRECEDING AND
> UNBOUNDED FOLLOWING}} and {{BETWEEN UNBOUNDED PRECEDING and CURRENT ROW}} now.
> 3. {{ORDER BY}} is required.
> 4. only one column is supported in {{PARTITION BY}} clause and {{ORDER BY}}
> clause.
> 5. support multiple {{OVER}} function but they must be in same window.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
