[FLINK-29219] CREATE TABLE AS statement blocks SQL client's execution

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 1.16.0
• Fix Version/s: 1.16.0, 1.17.0
• Component/s: Table SQL / API, Table SQL / Client
• Labels: pull-request-available
• Assignee: dalongliu
• Reporter: Qingsheng Ren
• Created: 07/Sep/22 07:56
• Updated: 01/Nov/22 08:47
• Resolved: 27/Sep/22 01:53

Description

When executing CREATE TABLE AS statement to create a sink table in SQL client, the client could create the table in catalog and submit the job to cluster successfully, but stops emitting new prompts and accepts new inputs, and user has to use SIGTERM (Control + C) to forcefully stop the SQL client. 

As contrast the behavior of INSERT INTO statement in SQL client is printing "Job is submitted with JobID xxxx" and being ready to accept user's input. 

From the log it looks like the client was waiting for the job to finish.

Issue Links

• links to: GitHub Pull Request #20858
• links to: GitHub Pull Request #20869
• links to: GitHub Pull Request #20880