You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@flink.apache.org by "jiwei (JIRA)" <ji...@apache.org> on 2018/12/29 04:53:00 UTC
[jira] [Created] (FLINK-11230) Sum of FlinkSql after two table
union all.The value is too large.
jiwei created FLINK-11230:
-----------------------------
Summary: 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
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.But the result is 60 per minute for per table.Is there an error in your SQL statement?
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)