You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "lilizhao (JIRA)" <ji...@apache.org> on 2018/03/12 09:59:00 UTC
[jira] [Issue Comment Deleted] (FLINK-8903) Error calculation based
on rolling window in table API and SQL API
[ https://issues.apache.org/jira/browse/FLINK-8903?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
lilizhao updated FLINK-8903:
----------------------------
Comment: was deleted
(was: Hi, [~fhueske] In my appendix example, the sum of the calculations, the average value can be calculated correctly. Only the variance is wrong. I gave the sample program and sample data that I finished. Please test it,you will know that.)
> 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: 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)