GitHub user sunjincheng121 opened a pull request:
https://github.com/apache/flink/pull/3743
[FLINK-6228][table] Integrating the OVER windows in the Table API (stâ¦
In this PR I had integrating the OVER windows in the Table API,
Implementation of the syntax and use examples are as followsï¼
* Syntax:
```
table
.overWindows(
(Rows|Range [ partitionBy value_expression , ... [ n ]] [ orderBy
order_by_expression]
(preceding
UNBOUNDED|value_specification.(rows|milli|second|minute|hour|day|month|year)|CURRENTROW)
[following
UNBOUNDED|value_specification.(rows|milli|second|minute|hour|day|month|year)|CURRENTROW]
as alias,...[n])
)
.select( [col1,...[n]], (agg(col1) OVER overWindowAlias, ⦠[n])
```
* examples:
```
// Rows clause
table
.window(Over partitionBy 'c orderBy 'rowTime preceding 2.rows as 'w1)
.select(
'c,
'b.count over 'w1 as 'countB,
'e.sum over 'w1 as 'sumE)
// Range clause
table
.window(Over partitionBy 'c orderBy 'rowTime preceding 2.milli as 'w1)
.select(
'c,
'b.count over 'w1 as 'countB,
'e.sum over 'w1 as 'sumE)
```
* More detail Info :
https://docs.google.com/document/d/13Z-Ovx3jwtmzkSweJyGkMy751BouhuJ29Y1CTNZt2DI/edit#
NOTE: The documentation of the OVER tableAPI not included in this PR.
- [x] General
- The pull request references the related JIRA issue
("[FLINK-6228][table] Integrating the OVER windows in the Table API")
- The pull request addresses only one issue
- Each commit in the PR has a meaningful commit message (including the
JIRA id)
- [ ] Documentation
- Documentation has been added for new functionality
- Old documentation affected by the pull request has been updated
- JavaDoc for public methods has been added
- [x] Tests & Build
- Functionality added by the pull request is covered by tests
- `mvn clean verify` has been executed successfully locally or a Travis
build has passed
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/sunjincheng121/flink FLINK-6228-PR
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/flink/pull/3743.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #3743
----
commit 03d4153be93d505cdb47d174e5aafe10eb93a45f
Author: sunjincheng121 <[email protected]>
Date: 2017-04-13T09:36:18Z
[FLINK-6228][table] Integrating the OVER windows in the Table API (stream)
----
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---
