You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Carl (Jira)" <ji...@apache.org> on 2021/11/09 04:33:00 UTC
[jira] [Updated] (FLINK-24836) Over window in month time calculated
an incorrect aggregation result.
[ 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:
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!
When i use over window in month, it don't throw any exception but calculated an incorrect aggregation result.
!image-2021-11-09-12-30-36-181.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)