[ https://issues.apache.org/jira/browse/FLINK-11230?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16732702#comment-16732702 ]
jiwei commented on FLINK-11230: ------------------------------- [~hequn8128],I have changed EventTimeTrigger to ContinuousEventTimeTrigger. Through testing, we found that it's useful to getting the correct __ result for a single stream.Why it's change the result by using union all and sum? > Sum of FlinkSql after two table union all.The value is too large. > ----------------------------------------------------------------- > > Key: FLINK-11230 > URL: https://issues.apache.org/jira/browse/FLINK-11230 > Project: Flink > Issue Type: Bug > Components: Table API & SQL > Affects Versions: 1.7.0 > Reporter: jiwei > Priority: Blocker > Labels: test > Attachments: image-2019-01-02-14-18-33-890.png, > image-2019-01-02-14-18-43-710.png, screenshot-1.png > > > SELECT k AS KEY, SUM(p) AS pv > FROM ( > SELECT tumble_start(stime, INTERVAL '1' minute) AS k > , COUNT(*) AS p > FROM flink_test1 > GROUP BY tumble(stime, INTERVAL '1' minute) > UNION ALL > SELECT tumble_start(stime, INTERVAL '1' minute) AS k > , COUNT(*) AS p > FROM flink_test2 > GROUP BY tumble(stime, INTERVAL '1' minute) > ) t > GROUP BY k > The Result of executing this sql is about 7000 per minute and keeping > increasing.But the result is 60 per minute for per table.Is there an error in > my SQL statement? -- This message was sent by Atlassian JIRA (v7.6.3#76005)