[
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 {{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.
was:
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.
> 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 {{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
(v6.3.15#6346)
