[FLINK-10676] Add 'as' method for OverWindowWithOrderBy in Java API

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.7.0
• Fix Version/s: 1.7.0
• Component/s: Table SQL / API
• Labels: pull-request-available
• Release Note: Change the over window preceding clause from required to optional.
• Assignee: Hequn Cheng
• Reporter: sunjincheng
• Created: 25/Oct/18 08:59
• Updated: 02/Oct/19 17:48
• Resolved: 08/Nov/18 04:17

Description

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.:

.window(Over partitionBy 'c orderBy 'proctime preceding UNBOUNDED_ROW as 'w)

Can be simplified as follows:

.window(Over partitionBy 'c orderBy 'proctime as 'w)

What do you think?

 

Issue Links

• links to: GitHub Pull Request #6949