[GitHub] flink pull request #3743: [FLINK-6228][table] Integrating the OVER windows i...

[sunjincheng121]

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 <sunjincheng...@gmail.com>
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 infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---