You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "pengcheng xiong (JIRA)" <ji...@apache.org> on 2014/08/16 08:41:18 UTC
[jira] [Updated] (HIVE-7736) improve the columns stats update speed
for all the partitions of a table
[ https://issues.apache.org/jira/browse/HIVE-7736?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
pengcheng xiong updated HIVE-7736:
----------------------------------
Attachment: HIVE-7736.0.patch
> improve the columns stats update speed for all the partitions of a table
> ------------------------------------------------------------------------
>
> Key: HIVE-7736
> URL: https://issues.apache.org/jira/browse/HIVE-7736
> Project: Hive
> Issue Type: Improvement
> Reporter: pengcheng xiong
> Assignee: pengcheng xiong
> Priority: Minor
> Attachments: HIVE-7736.0.patch
>
>
> 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
--
This message was sent by Atlassian JIRA
(v6.2#6252)