You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "jiwei (JIRA)" <ji...@apache.org> on 2019/01/02 06:21:00 UTC
[jira] [Commented] (FLINK-11230) Sum of FlinkSql after two table
union all.The value is too large.
[ https://issues.apache.org/jira/browse/FLINK-11230?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16731785#comment-16731785 ]
jiwei commented on FLINK-11230:
-------------------------------
Hi,[~hequn8128].
SELECT udf_dateformat(tumble_start(stime, INTERVAL '1' MINUTE), 'yyyyMMddHHmm') AS KEY ,
COUNT(*) AS pv
FROM flink_test1
GROUP BY tumble(stime, INTERVAL '1' MINUTE)
The result of this sql is as showed as below. There is about 60 per minute as same as table flink_test2. !screenshot-1.png!
However,the result is very large after them union all as showed below.
!image-2019-01-02-14-18-43-710.png!
Do you have any idea?Thanks for your attention!
> 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)