[FLINK-27344] FLIP-222: Support full job lifecycle statements in SQL client

• Type: New Feature
• Status: In Progress
• Priority: Major
• Resolution: Unresolved
• Component/s: Table SQL / Client
• Assignee: Paul Lin
• Reporter: Paul Lin
• Created: 22/Apr/22 02:18
• Updated: 01/Feb/23 06:38

Description

With the efforts in FLIP-24 and FLIP-91, Flink SQL client supports submitting SQL jobs but lacks further support for their lifecycles afterward which is crucial for streaming use cases. That means Flink SQL client users have to turn to other clients (e.g. CLI) or APIs (e.g. REST API) to manage the jobs, like triggering savepoints or canceling queries, which makes the user experience of SQL client incomplete.

Therefore, this proposal aims to complete the capability of SQL client by adding job lifecycle statements. With these statements, users could manage jobs and savepoints through pure SQL in SQL client.

Issue Links

• Testing discovered: FLINK-30811 Fix sql gateway can not stop job correctly

Sub-Tasks

• Support stop job statement in SQL client: Closed
• Support show jobs statement in SQL client: Resolved
• Support savepoint statements in SQL client: Resolved
• Support drop savepoint statement in SQL client: Resolved
• Support stop job statement in SqlGatewayService: Closed
• Support show jobs statement in SqlGatewayService: Closed
• Support savepoint statements in SqlGatewayService: Open
• Support drop savepoint statement in SqlGatewayService: Open
• Add document for job lifecycle statements: Closed
• Improve error handling of stop job operation: Closed