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)

Reply via email to