[
https://issues.apache.org/jira/browse/FLINK-25392?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Timo Walther closed FLINK-25392.
--------------------------------
Fix Version/s: 1.15.0
Release Note:
It is recommended to update statement sets to the new SQL syntax: EXECUTE
STATEMENT SET BEGIN ... END;
EXPLAIN STATEMENT SET BEGIN ... END;
Resolution: Fixed
Fixed in master: 6def8d7f81925517f5097c5662ed8ed06ec401e0
> 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
> Assignee: Wenlong Lyu
> Priority: Major
> Labels: pull-request-available
> Fix For: 1.15.0
>
>
> 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)
