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

["Zhenghua Gao (JIRA)" <ji...@apache.org>]

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

Zhenghua Gao edited comment on FLINK-9854 at 6/13/19 10:24 AM:
---------------------------------------------------------------

Hi [~yanghua]， Seems your point is multi-line with keyboard typing support. and my PR want to support multi-statements in sql script or copy-paste.

If I understand correctly, I will open a new issue to track my case. What do you think?


was (Author: docete):
Hi [~yanghua]， Seems your point is multi-line-single-statement support. and my PR want to support multi-statement.

If I understand correctly, I will open a new issue to track multi-statement case. What do you think?

> 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: Table SQL / Client
>            Reporter: Timo Walther
>            Assignee: vinoyang
>            Priority: Major
>              Labels: pull-request-available
>          Time Spent: 20m
>  Remaining Estimate: 0h
>
> 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)