[
https://issues.apache.org/jira/browse/FLINK-11230?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16731981#comment-16731981
]
Hequn Cheng commented on FLINK-11230:
-------------------------------------
[~jiweiautohome] It is wired that the global window outputs multi rows for
every minute. For example, there should be only one output for 201901021305
according to your sql. Have you grouped by other fields along with the window?
> 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)
