[
https://issues.apache.org/jira/browse/FLINK-8650?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16527888#comment-16527888
]
ASF GitHub Bot commented on FLINK-8650:
---------------------------------------
Github user fhueske commented on a diff in the pull request:
https://github.com/apache/flink/pull/6226#discussion_r199205419
--- Diff: docs/dev/table/sql.md ---
@@ -176,9 +181,20 @@ groupItem:
| ROLLUP '(' expression [, expression ]* ')'
| GROUPING SETS '(' groupItem [, groupItem ]* ')'
-insert:
- INSERT INTO tableReference
- query
+windowRef:
+ windowName
+ | windowSpec
+
+windowSpec:
--- End diff --
Can you also add a `WINDOW` example to the **Over Window aggregation**
section in
https://ci.apache.org/projects/flink/flink-docs-release-1.5/dev/table/sql.html#aggregations
?
> Add tests and documentation for WINDOW clause
> ---------------------------------------------
>
> Key: FLINK-8650
> URL: https://issues.apache.org/jira/browse/FLINK-8650
> Project: Flink
> Issue Type: Improvement
> Components: Table API & SQL
> Reporter: Timo Walther
> Assignee: Sergey Nuyanzin
> Priority: Major
> Labels: pull-request-available
>
> We support queries with a {{WINDOW}} clause like:
> {code}
> SELECT a, SUM(c) OVER w, MIN(c) OVER w FROM MyTable WINDOW w AS (PARTITION BY
> a ORDER BY proctime ROWS BETWEEN 4 PRECEDING AND CURRENT ROW)
> {code}
> But this is neither documented nor tested.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
