[
https://issues.apache.org/jira/browse/FLINK-8903?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16400654#comment-16400654
]
Fabian Hueske commented on FLINK-8903:
--------------------------------------
Hi [~lilizhao],
Sorry for being too eager when closing the issue!
You are right, this is a bug. I reproduced the issue and also found the cause
of the bug.
Let me see, if there's an easy way to fix it.
In worst case, we need to disable some of the aggregation functions.
Best, Fabian
> Error calculation based on rolling window in table API and SQL API
> ------------------------------------------------------------------
>
> Key: FLINK-8903
> URL: https://issues.apache.org/jira/browse/FLINK-8903
> Project: Flink
> Issue Type: Bug
> Components: Table API & SQL
> Affects Versions: 1.4.1
> Reporter: lilizhao
> Priority: Critical
> Fix For: 1.5.0
>
> Attachments: QQ图片20180312180143.jpg, TableAndSQLTest.java
>
>
> Error calculation based on rolling window in table API and SQL API
> The variance of the calculation is equal to the average.
> 1 The test code is detailed in the appendix
> 2 The test data are as follows
> 1 li
> 100 li
> 3 The Table API test result as follows
> (true,50.5,101.0,50.5,li,2018-03-09 09:11:00.0)
> 4 The SQL API test result as follows
> (true,50.5,2,101.0,50.5,li,2018-03-09 09:21:00.0)
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
