[
https://issues.apache.org/jira/browse/HIVE-7506?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14094322#comment-14094322
]
pengcheng xiong commented on HIVE-7506:
---------------------------------------
done updating the review base (RB?)
Thanks!
Best
Pengcheng Xiong
pxi...@hortonworks.com
--
CONFIDENTIALITY NOTICE
NOTICE: This message is intended for the use of the individual or entity to
which it is addressed and may contain information that is confidential,
privileged and exempt from disclosure under applicable law. If the reader
of this message is not the intended recipient, you are hereby notified that
any printing, copying, dissemination, distribution, disclosure or
forwarding of this communication is strictly prohibited. If you have
received this communication in error, please contact the sender immediately
and delete it from your system. Thank You.
> MetadataUpdater: provide a mechanism to edit the statistics of a column in a
> table (or a partition of a table)
> --------------------------------------------------------------------------------------------------------------
>
> Key: HIVE-7506
> URL: https://issues.apache.org/jira/browse/HIVE-7506
> Project: Hive
> Issue Type: New Feature
> Components: Statistics
> Reporter: pengcheng xiong
> Assignee: pengcheng xiong
> Priority: Minor
> Attachments: HIVE-7506.1.patch, HIVE-7506.3.patch, HIVE-7506.4.patch,
> HIVE-7506.5.patch, HIVE-7506.patch
>
> Original Estimate: 252h
> Remaining Estimate: 252h
>
> Two motivations:
> (1) Cost-based Optimizer (CBO) depends heavily on the statistics of a column
> in a table (or a partition of a table). If we would like to test whether CBO
> chooses the best plan under different statistics, it would be time consuming
> if we load the whole table and create the statistics from ground up.
> (2) As database runs, the statistics of a column in a table (or a partition
> of a table) may change. We need a way or a mechanism to synchronize.
> We propose the following command to achieve that:
> ALTER TABLE table_name PARTITION partition_spec [COLUMN col_name] UPDATE
> STATISTICS col_statistics [COMMENT col_comment]
--
This message was sent by Atlassian JIRA
(v6.2#6252)
