[ https://issues.apache.org/jira/browse/FLINK-24836?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Carl updated FLINK-24836: ------------------------- 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._ !image-2021-11-09-12-30-25-311.png! 2. When i use over window in month, it don't throw any exception but calculated an incorrect aggregation result. !image-2021-11-09-12-32-04-053.png! !image-2021-11-09-12-30-54-375.png! was: 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._ !image-2021-11-09-12-30-25-311.png! 2. When i use over window in month, it don't throw any exception but calculated an incorrect aggregation result. !image-2021-11-09-12-32-04-053.png! !image-2021-11-09-12-30-54-375.png! > Over window in month time calculated an incorrect aggregation result. > --------------------------------------------------------------------- > > Key: FLINK-24836 > URL: https://issues.apache.org/jira/browse/FLINK-24836 > Project: Flink > Issue Type: Bug > Components: Table SQL / Planner > Affects Versions: 1.13.1 > Reporter: Carl > Priority: Major > Attachments: image-2021-11-09-12-30-25-311.png, > image-2021-11-09-12-30-36-181.png, image-2021-11-09-12-30-54-375.png, > image-2021-11-09-12-32-04-053.png > > > 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._ > !image-2021-11-09-12-30-25-311.png! > > 2. When i use over window in month, it don't throw any exception but > calculated an incorrect aggregation result. > !image-2021-11-09-12-32-04-053.png! > > !image-2021-11-09-12-30-54-375.png! > > -- This message was sent by Atlassian Jira (v8.20.1#820001)