[FLINK-6228] Integrating the OVER windows in the Table API

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Implemented
• Fix Version/s: 1.3.0
• Component/s: Table SQL / API
• Assignee: sunjincheng
• Reporter: sunjincheng
• Created: 31/Mar/17 09:19
• Updated: 24/Apr/17 18:59
• Resolved: 24/Apr/17 18:59

Description

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])

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 implementation orderBy may only have ‘rowtime/’proctime(for stream)/‘specific-time-field(for batch).
• FOLLOWING is not supported.

User interface design document See

Issue Links

• is duplicated by: FLINK-4680 Add SlidingRow row-windows to Table API
• links to: GitHub Pull Request #3743