You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@flink.apache.org by "lilizhao (JIRA)" <ji...@apache.org> on 2018/03/09 09:26:00 UTC

[jira] [Created] (FLINK-8903) Error calculation based on rolling window in table API and SQL API

lilizhao created FLINK-8903:
-------------------------------

             Summary: 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 &amp; SQL
    Affects Versions: 1.4.1
            Reporter: lilizhao
             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)