[FLINK-22540] Remove YAML environment file support in SQL Client

• Type: Sub-task
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 1.14.0
• Component/s: Table SQL / Client
• Labels: auto-unassigned pull-request-available

Release Note

The sql-client-defaults.yaml YAML file was deprecated in 1.13 release and now it is completely removed in this release. As an alternative, you can use the -i startup option to execute an initialization SQL file to setup the SQL Client session. The 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. See more: https://nightlies.apache.org/flink/flink-docs-release-1.14/docs/dev/table/sqlclient/#initialize-session-using-sql-files

• Assignee: Shengkai Fang
• Reporter: Jark Wu
• Created: 30/Apr/21 09:07
• Updated: 09/Sep/21 12:07
• Resolved: 26/Jul/21 12:10

Description

As discussed in https://cwiki.apache.org/confluence/display/FLINK/FLIP-163%3A+SQL+Client+Improvements,
YAML environment file is deprecated in 1.13 version and should be removed in 1.14 version. Users are recommended to use SQL script to initialize session.

Issue Links

• is blocked by: FLINK-22694 Refactor TPCH end to end tests
• is blocked by: FLINK-23446 Refactor SQL Client end to end tests
• is blocked by: FLINK-23455 Remove the usage of the yaml file in SQLJobSubmission
• is blocked by: FLINK-23467 Remove the usage of the yaml file in pyflink e2e test
• relates to: FLINK-16421 Changing default catalog to hive without changing default database fails
• relates to: FLINK-17158 Watermark strategy property cannot be expressed in YAML
• relates to: FLINK-17349 Reduce runtime of LocalExecutorITCase
• relates to: FLINK-23446 Refactor SQL Client end to end tests
• relates to: FLINK-14661 rename args of setters in sql cli Environment class
• relates to: FLINK-18273 Test and document deployment section in SQL Client
• links to: GitHub Pull Request #16563