[ https://issues.apache.org/jira/browse/FLINK-8650?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16527964#comment-16527964 ]
ASF GitHub Bot commented on FLINK-8650: --------------------------------------- Github user snuyanzin commented on a diff in the pull request: https://github.com/apache/flink/pull/6226#discussion_r199223615 --- 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: + [ windowName ] + '(' + [ ORDER BY orderItem [, orderItem ]* ] + [ PARTITION BY expression [, expression ]* ] + [ + RANGE numericOrIntervalExpression { PRECEDING | FOLLOWING } --- End diff -- Yes agree I've removed it > 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)