[FLINK-9854] Allow passing multi-line input to SQL Client CLI

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Component/s: Table SQL / Client
• Labels: auto-unassigned pull-request-available
• Assignee: Unassigned
• Reporter: Timo Walther
• Created: 15/Jul/18 20:02
• Updated: 29/Apr/21 09:58
• Resolved: 29/Apr/21 09:58

Description

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.

Issue Links

• links to: GitHub Pull Request #7960