[
https://issues.apache.org/jira/browse/FLINK-8903?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Fabian Hueske updated FLINK-8903:
---------------------------------
Description:
The built-in aggregation functions
was:
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)
> Built-in agg functions VAR_POP, VAR_SAMP, STDEV_POP, STDEV_SAMP are broken in
> Group Windows
> -------------------------------------------------------------------------------------------
>
> Key: FLINK-8903
> URL: https://issues.apache.org/jira/browse/FLINK-8903
> Project: Flink
> Issue Type: Bug
> Components: Table API & SQL
> Affects Versions: 1.3.2, 1.5.0, 1.4.2
> Reporter: lilizhao
> Priority: Critical
> Fix For: 1.5.0
>
> Attachments: QQ图片20180312180143.jpg, TableAndSQLTest.java
>
>
> The built-in aggregation functions
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
