[
https://issues.apache.org/jira/browse/FLINK-9854?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16789455#comment-16789455
]
Timo Walther commented on FLINK-9854:
-------------------------------------
Multi-statement input would mean that we execute multiple statements such as
{{CREATE VIEW x}} followed by {{CREATE VIEW y}} followed by {{INSERT
INTO...FROM y}} as in a "SQL script". However, we don't have a proper parser
for separating statements of a SQL script so far. This will come with DDL
support. If you would like to work on this issue, we could start with piping
single statements (that might be spread across multiple lines).
> Allow passing multi-line input to SQL Client CLI
> ------------------------------------------------
>
> Key: FLINK-9854
> URL: https://issues.apache.org/jira/browse/FLINK-9854
> Project: Flink
> Issue Type: Sub-task
> Components: API / Table SQL, SQL / Client
> Reporter: Timo Walther
> Assignee: vinoyang
> Priority: Major
>
> We should support {{flink-cli < query01.sql}} or {{echo "INSERT INTO bar
> SELECT * FROM foo" | flink-cli}} for convenience. I'm not sure how well we
> support multilines and EOF right now. Currenlty, with the experimental {{-u}}
> flag the user also gets the correct error code after the submission, with
> {{flink-cli < query01.sql}} the CLI would either stay in interactive mode or
> always return success.
> We should also discuss which statements are allowed. Actually, only DDL and
> {{INSERT INTO}} statements make sense so far.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
