[FLINK-29069] Release Testing: Verify FLIP-218 Create table as select syntax

• Type: Sub-task
• Status: Closed
• Priority: Blocker
• Resolution: Resolved
• Affects Version/s: 1.16.0
• Fix Version/s: 1.16.0
• Component/s: Table SQL / API
• Labels: release-testing
• Assignee: Qingsheng Ren
• Reporter: dalongliu
• Created: 23/Aug/22 01:51
• Updated: 07/Sep/22 08:13
• Resolved: 07/Sep/22 08:13

Description

This issue aims to verify FLIP-218: https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=199541185

We can verify it in SQL client after we build the flink-dist package.

1. Creating a source table firstly
2. Creating a target table using the source table
3. Verify the result when the query is executed successfully/failed/canceled.
4. Verify the ctas query in streaming and batch mode.