[FLINK-31767] Improve the implementation for "analyze table" execution on partitioned table

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.18.0
• Component/s: Table SQL / Planner
• Labels: pull-request-available
• Assignee: Godfrey He
• Reporter: Godfrey He
• Created: 11/Apr/23 06:43
• Updated: 13/Apr/23 04:04
• Resolved: 13/Apr/23 04:04

Description

Currently, for partitioned table, the "analyze table" command will generate a separate SQL statement for each partition. When there are too many partitions, the compilation/submission/execution time will be very long. This issue aims to improve it: we can combine the sql statements for each partition into one with "union all", and just need to execution one sql.

Issue Links

• links to: GitHub Pull Request #22376