[FLINK-9740] Support group windows over intervals of months - ASF JIRA

Agile Board

Rank to Top

Rank to Bottom

Attach files

Attach Screenshot

Bulk Copy Attachments

Bulk Move Attachments

Add vote

Voters

Stop watching

Watchers

Create sub-task

Convert to sub-task

Link

Clone

Labels

Update Comment Author

Replace String in Comment

Update Comment Visibility

Delete Comments

XML

Word

Printable

JSON

Details

Type: New Feature
Status: Open
Priority: Not a Priority
Resolution: Unresolved
Affects Version/s: 1.5.0
Fix Version/s: None
Component/s: Table SQL / API
Labels:

Description

Currently, time-based group windows can be defined using intervals of milliseconds such as .window(Tumble over 10.minutes on 'rowtime as 'w). For some use cases it might useful to define windows of months (esp. in event-time) that work even with leap years and other special time cases.

The following should be supported in Table API & SQL:

.window(Tumble over 1.month on 'rowtime as 'w)
.window(Tumble over 1.quarter on 'rowtime as 'w)
.window(Tumble over 1.year on 'rowtime as 'w)