flink-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "sunjincheng (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (FLINK-6228) Integrating the OVER windows in the Table API
Date Wed, 05 Apr 2017 04:44:41 GMT

     [ https://issues.apache.org/jira/browse/FLINK-6228?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

sunjincheng updated FLINK-6228:
-------------------------------
    Description: 
Syntax:

{code}
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])
{code}

Implement restrictions:
* All OVER clauses in the same SELECT clause must be exactly the same.
* The PARTITION BY clause is optional (no partitioning results in single threaded execution).
* The ORDER BY Before the [FLINK-5884|https://issues.apache.org/jira/browse/FLINK-5884]  implementation
orderBy may only have ‘rowtime/’proctime(for stream)/‘specific-time-field(for batch).
** FOLLOWING is not supported.

I will soon add a user interface design document.


  was:
Syntax:

{code}
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])
{code}

Implement restrictions:
** All OVER clauses in the same SELECT clause must be exactly the same.
** The PARTITION BY clause is optional (no partitioning results in single threaded execution).
** The ORDER BY Before the [FLINK-5884|https://issues.apache.org/jira/browse/FLINK-5884] 
implementation orderBy may only have ‘rowtime/’proctime(for stream)/‘specific-time-field(for
batch).
** FOLLOWING is not supported.

I will soon add a user interface design document.



> Integrating the OVER windows in the Table API
> ---------------------------------------------
>
>                 Key: FLINK-6228
>                 URL: https://issues.apache.org/jira/browse/FLINK-6228
>             Project: Flink
>          Issue Type: Sub-task
>          Components: Table API & SQL
>            Reporter: sunjincheng
>            Assignee: sunjincheng
>
> Syntax:
> {code}
> 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])
> {code}
> Implement restrictions:
> * All OVER clauses in the same SELECT clause must be exactly the same.
> * The PARTITION BY clause is optional (no partitioning results in single threaded execution).
> * The ORDER BY Before the [FLINK-5884|https://issues.apache.org/jira/browse/FLINK-5884]
 implementation orderBy may only have ‘rowtime/’proctime(for stream)/‘specific-time-field(for
batch).
> ** FOLLOWING is not supported.
> I will soon add a user interface design document.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message