[HIVE-28299] Iceberg: Optimize show partitions through column projection

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 4.1.0
• Component/s: Iceberg integration
• Labels: pull-request-available
• Target Version/s: 4.1.0
• Assignee: Butao Zhang
• Reporter: Butao Zhang
• Created: 04/Jun/24 07:21
• Updated: 21/Jun/24 14:26
• Resolved: 20/Jun/24 12:38

Description

In the current show partitions implementation, we need to fetch all columns data, but in fact we only need two columns data, partition & spec_id.

We can only fetch the two columns through column project, and this can improve the performance in case of big iceberg partition table.

Issue Links

• links to: GitHub Pull Request #5276