[ https://issues.apache.org/jira/browse/FLINK-8903?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Fabian Hueske closed FLINK-8903. -------------------------------- Resolution: Not A Problem Hi [~lilizhao], processing time is inherently non-deterministic, i.e., different executions produce different results. You have to use event time if you want more accurate results. Closing this issue as "Not a Problem" > 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)