[ 
https://issues.apache.org/jira/browse/HIVE-28170?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18100519#comment-18100519
 ] 

Soumyakanti Das commented on HIVE-28170:
----------------------------------------

HIVE-27964 suggests lots of features but currently we only support dropping all 
column stats from the table usingĀ 
{noformat}
ALTER TABLE <table name> DROP STATISTICS FOR COLUMNS;{noformat}
I don't think we have plans to implement other suggestions in HIVE-27964 at 
this moment.

> Implement drop stats
> --------------------
>
>                 Key: HIVE-28170
>                 URL: https://issues.apache.org/jira/browse/HIVE-28170
>             Project: Hive
>          Issue Type: Task
>            Reporter: Ramesh Kumar Thangarajan
>            Assignee: Ramesh Kumar Thangarajan
>            Priority: Major
>              Labels: pull-request-available
>             Fix For: 4.3.0
>
>
> We need a way to drop the stats associated with the table/partition and its 
> columns. This can help a lot in migration or replication where the stats data 
> take huge time to copy. Particularly when the table is partitioned, we have 
> stats rows for each table, partition, column combination, which can get huge 
> when the number of partitions is huge.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to