[
https://issues.apache.org/jira/browse/FLINK-10676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16678405#comment-16678405
]
ASF GitHub Bot commented on FLINK-10676:
----------------------------------------
hequn8128 commented on a change in pull request #6949: [FLINK-10676][table] Add
'as' method for OverWindowWithOrderBy
URL: https://github.com/apache/flink/pull/6949#discussion_r231555804
##########
File path: docs/dev/table/tableApi.md
##########
@@ -1571,13 +1571,15 @@ The `OverWindow` defines a range of rows over which
aggregates are computed. `Ov
</tr>
<tr>
<td><code>preceding</code></td>
- <td>Required</td>
+ <td>Optional</td>
<td>
<p>Defines the interval of rows that are included in the window and
precede the current row. The interval can either be specified as time or
row-count interval.</p>
<p><a href="tableApi.html#bounded-over-windows">Bounded over
windows</a> are specified with the size of the interval, e.g.,
<code>10.minutes</code> for a time interval or <code>10.rows</code> for a
row-count interval.</p>
<p><a href="tableApi.html#unbounded-over-windows">Unbounded over
windows</a> are specified using a constant, i.e., <code>UNBOUNDED_RANGE</code>
for a time interval or <code>UNBOUNDED_ROW</code> for a row-count interval.
Unbounded over windows start with the first row of a partition.</p>
+
+ <p>If the <code>preceding</code> and <code>following</code> clause
both are omitted, RANGE UNBOUNDED PRECEDING AND CURRENT ROW is used as default
for window.</p>
Review comment:
make sense!
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
> Add 'as' method for OverWindowWithOrderBy in Java API
> -----------------------------------------------------
>
> Key: FLINK-10676
> URL: https://issues.apache.org/jira/browse/FLINK-10676
> Project: Flink
> Issue Type: Improvement
> Components: Table API & SQL
> Affects Versions: 1.7.0
> Reporter: sunjincheng
> Assignee: Hequn Cheng
> Priority: Major
> Labels: pull-request-available
> Fix For: 1.7.0
>
>
> The preceding clause of OVER Window in the traditional database is optional.
> The default is UNBOUNDED. So we can add the "as" method to
> OverWindowWithOrderBy. This way OVERWindow is written more easily. e.g.:
> {code:java}
> .window(Over partitionBy 'c orderBy 'proctime preceding UNBOUNDED_ROW as
> 'w){code}
> Can be simplified as follows:
> {code:java}
> .window(Over partitionBy 'c orderBy 'proctime as 'w){code}
> What do you think?
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
