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

Fri, 09 Mar 2018 01:26:58 -0800 

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 & 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)

Reply via email to