Details
-
Improvement
-
Status: Closed
-
Minor
-
Resolution: Fixed
-
None
-
None
-
None
Description
The current implementation of columns stats update for all the partitions of a table takes a long time when there are thousands of partitions.
For example, on a given cluster, it took 600+ seconds to update all the partitions' columns stats for a table with 2 columns but 2000 partitions.
ANALYZE TABLE src_stat_part partition (partitionId) COMPUTE STATISTICS for columns;
We would like to improve the columns stats update speed for all the partitions of a table
Attachments
Attachments
Issue Links
- links to