flink-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "godfrey he (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (FLINK-6238) support OVER on batch SQL
Date Sat, 01 Apr 2017 07:12:41 GMT

     [ 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)

Mime
View raw message