[
https://issues.apache.org/jira/browse/FLINK-6238?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
godfrey he updated FLINK-6238:
------------------------------
Description:
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 {{ROWS 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.
was:
The syntax of the OVER clause is:
<function> OVER ( [PARTITION BY clause]
[ORDER BY clause]
[ROWS or RANGE clause] )
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 ROWS 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.
> 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
>
> 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 {{ROWS 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
(v6.3.15#6346)
