[SPARK-45731] Update partition statistics with ANALYZE TABLE command

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.0.0
• Fix Version/s: 4.0.0
• Component/s: SQL
• Labels: pull-request-available
• Assignee: Chao Sun
• Reporter: Chao Sun
• Created: 30/Oct/23 23:28
• Updated: 15/Nov/23 03:38
• Resolved: 09/Nov/23 23:56

Description

Currently ANALYZE TABLE command only updates table-level stats but not partition stats, even though it can be applied to both non-partitioned and partitioned tables. It seems make sense for it to update partition stats as well.

Note users can use ANALYZE TABLE PARTITION(..) to get the same effect, but the syntax is more verbose as they need to specify all the partition columns.

Issue Links

• links to: GitHub Pull Request #43629