[FLINK-24836] Over window in month time calculated an incorrect aggregation result.

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.13.1
• Component/s: Table SQL / Planner
• Assignee: Unassigned
• Reporter: Carl
• Created: 09/Nov/21 04:30
• Updated: 09/Nov/21 12:50

Description

1. When i use tumble window in month, it throw an exception:

Window aggregate only SECOND, MINUTE, HOUR, DAY as the time unit. MONTH and YEAR time unit are not supported yet.

 

2. When i use over window in month, it don't throw any exception but calculated an incorrect aggregation result.