You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Zhenghua Gao (JIRA)" <ji...@apache.org> on 2019/06/13 08:15: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=16862814#comment-16862814 ]
Zhenghua Gao commented on FLINK-9854:
-------------------------------------
Actually Semicolon is the standard way to separate each SQL statement in database systems. And Apache Calcite has implemented this by [CALCITE-2310|https://issues.apache.org/jira/browse/CALCITE-2310].
I have a PR to allow multiple statements by split the user's input by semicolon and execute them one by one.
> 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)