[jira] [Closed] (FLINK-25392) Add new STATEMENT SET syntax

["Timo Walther (Jira)" <ji...@apache.org>]

     [ 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)