You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Sohan Jain (JIRA)" <ji...@apache.org> on 2011/07/08 21:09:16 UTC

[jira] [Updated] (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 ]

Sohan Jain updated HIVE-2219:
-----------------------------

    Attachment: HIVE-2219.2.patch

This patch is the correct one from ReviewBoard

> 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, HIVE-2219.2.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