flink-dev mailing list archives

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

Mime
View raw message