You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@flink.apache.org by "vinoyang (JIRA)" <ji...@apache.org> on 2019/03/11 09:41:00 UTC

[jira] [Commented] (FLINK-9854) Allow passing multi-line input to SQL Client CLI

    [ https://issues.apache.org/jira/browse/FLINK-9854?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16789347#comment-16789347 ] 

vinoyang commented on FLINK-9854:
---------------------------------

Activate this issue, [~twalthr] What is your current thinking? In the Linux shell, multiple lines of input can be supported with "\". Of course, in the Flink SQL client, we can use "|". Also, do you mean that we also need to support the execution of SQL scripts?

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