[FLINK-20320] Support start SQL Client with an initialization SQL file

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.13.0
• Component/s: Table SQL / Client
• Labels: pull-request-available

Release Note

The `sql-client-defaults.yaml` YAML file is deprecated and not provided in the release package. To be compatible, it's still supported to initialize the SQL Client with the YAML file if manually provided. But it's recommend to use the new introduced `-i` startup option to execute an initialization SQL file to setup the SQL Client session. The so-called initialization SQL file can use Flink DDLs to define available catalogs, table sources and sinks, user-defined functions, and other properties required for execution and deployment. The support of legacy SQL Client YAML file will be totally dropped in Flink 1.14.

• Assignee: Shengkai Fang
• Reporter: Jark Wu
• Created: 24/Nov/20 11:12
• Updated: 28/Aug/21 11:13
• Resolved: 23/Apr/21 12:59

Description

As discussed in FLINK-20260, it would be helpful to predefine some meta information when starting SQL CLI. This can be a replacement of YAML file which defines meta informations.

Hive supports start with an initialization SQL file "hive -i init.sql": https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Cli

I think we can also support that.

Issue Links

• is blocked by: FLINK-12828 Support -f option with a sql script file as input
• relates to: FLINK-20260 YAML for SQL client only supports legacy interfaces
• links to: GitHub Pull Request #15437