You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "godfrey he (JIRA)" <ji...@apache.org> on 2017/04/01 07:12:41 UTC
[jira] [Updated] (FLINK-6238) support OVER on batch SQL
[ 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:
{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 {{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)