[FLINK-29941] Support SQL Client connects to SQL Gateway

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: 2.0.0
• Component/s: Table SQL / Client, Table SQL / Gateway
• Assignee: Unassigned
• Reporter: Jark Wu
• Created: 09/Nov/22 02:57
• Updated: 10/Jul/24 06:57

Description

This is an umbrella issue to track the effort to support SQL Client connects to SQL Gateway, including SQL Client refactoring, end-to-end tests, and documentation.

Design Docs: https://docs.google.com/document/d/14cS4VBSamMUnlM_PZuK6QKLfriUuQU51iqET5oiYy_c/edit#heading=h.xfpxlv5v61pg

Issue Links

• causes: FLINK-30936 Release Testing: Verify FLINK-29941 Support SQL Client connects to SQL Gateway
• split from: FLINK-29073 [FLIP-91] Support SQL Gateway(Part 2)

Sub-Tasks

• Introduce Client Result to wrap the ResultSet returned by SQL Gateway: Resolved
• Introduce Client Parser to get statement type: Closed
• Supports to submit SQL to a embedded SQL Gateway in the SQL Client: Closed
• Introduce ‘ErrorDetail’ in SQL Gateway Rest Endpoint for error handling: Closed
• Support configuring session API in Gateway RestEndpoint: Closed
• Implement 'RemoteExecutor' to perform the communication with Gateway: Closed
• Add Statement Completement API for sql gateway rest endpoint: Closed
• Add configureSession REST API in the SQL Gateway: Closed
• Refactor ResultSet to an interface: Resolved
• Modify sql-client.sh: Closed
• Remove useless session id in the Sql Client Executor: Closed
• Decompose printing logic from Executor: Closed
• SQL Client supports to specify endpoint address: Closed
• Introduce embedded session manager to support REMOVE JAR: Closed
• Fix Sql Client always uses the packaged highests version to connect to gateway: Closed
• Fix sql client print an empty line between the multi-line statements: Closed
• Improve the SQL Client code structure: Closed
• Fix resource leak when creating Executor: Closed
• Add docs for the SQL Client gateway mode: Closed
• Add rootCause for ErrorResponse: Open
• Rework the CliClientITCase to extend AbstractSqlGatewayStatementITCase: Open
• Merge query files and processing in sql client and gateway: Open