You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@flink.apache.org by "godfrey he (JIRA)" <ji...@apache.org> on 2017/04/01 07:10:41 UTC

[jira] [Created] (FLINK-6238) support OVER on batch SQL

godfrey he created FLINK-6238:
---------------------------------

             Summary: 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:

<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.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)