[ https://issues.apache.org/jira/browse/FLINK-11230?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16732986#comment-16732986 ]
Hequn Cheng commented on FLINK-11230: ------------------------------------- [~jiweiautohome] The bottom aggregate after window will still output values bigger than what you expected even for a single stream. If you want to get early fired results, you can use non-window aggregate. For example, you can write sql as follows: {code:java} SELECT minuteTime, count(*) AS pv FROM ( SELECT getMinute(stime) as minuteTime FROM flink_test1 UNION ALL SELECT getMinute(stime) as minuteTime FROM flink_test2 ) t GROUP BY minuteTime {code} > 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)