[FLINK-28953] Release Testing: Verify FLIP-91 SQL Gateway

• Type: Sub-task
• Status: Closed
• Priority: Blocker
• Resolution: Done
• Affects Version/s: 1.16.0
• Fix Version/s: 1.16.0
• Component/s: Table SQL / Gateway
• Labels: release-testing
• Assignee: Jun He
• Reporter: Shengkai Fang
• Created: 15/Aug/22 02:18
• Updated: 07/Sep/22 06:47
• Resolved: 07/Sep/22 06:47

Description

SQL Gateway is ready to submit SQL with REST Endpoint. I think we should verify:

1. ./sql-gateway.sh start and stop the SQL Gateway and using REST API to submit a job
2. running SQL Gateway with standalone/yarn-session cluster
3. verify SELECT in batch/streaming mode:
   1. the RowKind is correct(+I/-UB/+UA/-D)
   2. fetch with token
4. verify add jar is ready in the gateway side, the downloaded resource will be cleaned after exits.

Issue Links

• is a parent of: FLINK-29184 SQL Gateway should remove the downloaded resources