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