[
https://issues.apache.org/jira/browse/HIVE-14729?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15478679#comment-15478679
]
Ashutosh Chauhan commented on HIVE-14729:
-----------------------------------------
yeah.. with auto gather stats they never need to run any analyze statements..
without it it will be good to run just 1, instead of current 2.
> analyze table compute stats for columns should collect basic stats as well
> --------------------------------------------------------------------------
>
> Key: HIVE-14729
> URL: https://issues.apache.org/jira/browse/HIVE-14729
> Project: Hive
> Issue Type: Improvement
> Components: Statistics
> Reporter: Ashutosh Chauhan
>
> Currently user need to run following two statements to collect stats:
> {code}
> analyze table T compute statistics;
> analyze table T compute statistics for columns;
> {code}
> Its little confusing for users that they need to collect both stats. Since
> basic stats are cheap to compute, we should collect them even in case of
> column stats, so that by running single statement users can get all stats.
> This leaves with the possibility of fast basic stats collection with first
> statement which will be good to have.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)