[FLINK-21454] FLIP-163: SQL Client Improvements

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.13.0
• Component/s: Table SQL / Client
• Labels: pull-request-available
• Assignee: Shengkai Fang
• Reporter: Shengkai Fang
• Created: 23/Feb/21 09:26
• Updated: 13/Aug/21 03:58
• Resolved: 13/Aug/21 03:58

Description

This is an umberlla jira for FLIP-163.

Issue Links

• incorporates: FLINK-12828 Support -f option with a sql script file as input
• is a parent of: FLINK-18788 Refactor sql-client based the proposed interfaces of FLIP-84
• is related to: FLINK-16441 Allow users to override flink-conf parameters from SQL CLI environment
• is related to: FLINK-21456 TableResult#print() should correctly stringify values

Sub-Tasks

• Use Configuration to create TableEnvironment: Closed
• Simplify the ExecutionContext: Closed
• Use configuration to store the option and value in Sql client: Closed
• Support parsing special commands by introducing ExtendedParser: Closed
• Loosen argument of TableEnvironmentInternal#executeInternal from QueryOperation to Operation: Closed
• Unify SQL Client parser and TableEnvironment parser: Closed
• Support STATEMENT SET in SQL CLI: Closed
• Support to parse STATEMENT SET syntax: Closed
• Support Explain Query/Modifcation syntax in Calcite Parser: Closed
• Support "table.dml-sync" option to execute DML statements synchronizely in TableEnvironment and SQL Client: Closed
• Support -f option with a sql script file as input: Closed
• Support start SQL Client with an initialization SQL file: Closed
• Support ADD JAR command in sql client: Closed
• Support SHOW JARS statement in SQL Client: Closed
• Support REMOVE JAR statement in SQL Client: Closed
• Support ExplainDetails for EXPLAIN sytnax: Closed
• Support SHOW CREATE TABLE command in SQL Client and TableEnvironment: Closed
• Make "embedded" parameter optional when start sql-client.sh: Closed
• Support "SHOW USER FUNCTIONS" statement: Closed
• Introduce a new integration test framework for SQL Client: Closed
• Support "RESET key" statement in the SQL Client: Closed
• Support option `sql-client.verbose` to print the exception stack: Closed
• Display result of all the SHOW command in tableau format: Closed
• Introduce DESC grammar in sql parser: Closed
• Add documentation for the DESC statement syntax: Closed
• Add show views test in CliClientITCase: Closed
• Update the doc about SQL Client: Closed
• Remove YAML environment file support in SQL Client: Closed
• Add document about add jar related commands: Closed