You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@flink.apache.org by "Timo Walther (Jira)" <ji...@apache.org> on 2021/12/20 12:57:00 UTC
[jira] [Created] (FLINK-25392) Add new STATEMENT SET syntax
Timo Walther created FLINK-25392:
------------------------------------
Summary: Add new STATEMENT SET syntax
Key: FLINK-25392
URL: https://issues.apache.org/jira/browse/FLINK-25392
Project: Flink
Issue Type: Sub-task
Components: Table SQL / API
Reporter: Timo Walther
Support:
{code}
EXECUTE STATEMENT SET
BEGIN
INSERT INTO pageview_pv_sink
SELECT page_id, count(1) FROM clicks GROUP BY page_id;
INSERT INTO pageview_uv_sink
SELECT page_id, count(distinct user_id) FROM clicks GROUP BY page_id;
END;
{code}
{code}
EXPLAIN STATEMENT SET
BEGIN
INSERT INTO pageview_pv_sink
SELECT page_id, count(1) FROM clicks GROUP BY page_id;
INSERT INTO pageview_uv_sink
SELECT page_id, count(distinct user_id) FROM clicks GROUP BY page_id;
END;
{code}
This time we should add this to the SQL parser. We need to figure out a solution for the interactive SQL Client.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)