You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Paul Yang (JIRA)" <ji...@apache.org> on 2011/07/06 19:51:16 UTC

[jira] [Resolved] (HIVE-2219) Make "alter table drop partition" more efficient

     [ https://issues.apache.org/jira/browse/HIVE-2219?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Paul Yang resolved HIVE-2219.
-----------------------------

       Resolution: Fixed
    Fix Version/s: 0.8.0

Committed. Thanks Sohan!

> Make "alter table drop partition" more efficient
> ------------------------------------------------
>
>                 Key: HIVE-2219
>                 URL: https://issues.apache.org/jira/browse/HIVE-2219
>             Project: Hive
>          Issue Type: Improvement
>          Components: Query Processor
>            Reporter: Sohan Jain
>            Assignee: Sohan Jain
>             Fix For: 0.8.0
>
>         Attachments: HIVE-2219.1.patch
>
>
> The current function dropTable() that handles dropping multiple partitions is somewhat inefficient.  For each partition you want to drop, it loops through each partition in the table to see if the partition exists.  This is an _O(mn)_ operation, where _m_ is the number of partitions to drop, and _n_ is the number of partitions in the table.  The running time of this function can be improved, which is useful for tables with many partitions.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira