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

["Paul Yang (JIRA)" <ji...@apache.org>]

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

Paul Yang commented on HIVE-2219:
---------------------------------

Can you make a reviewboard instance?

> 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
>         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