flink-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "lilizhao (JIRA)" <j...@apache.org>
Subject [jira] [Created] (FLINK-8903) Error calculation based on rolling window in table API and SQL API
Date Fri, 09 Mar 2018 09:26:00 GMT
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)

Mime
View raw message