hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Paul Yang (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-2219) Make "alter table drop partition" more efficient
Date Fri, 08 Jul 2011 21:05:17 GMT

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

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

I likely mixed up the RB and JIRA versions - looking at HIVE-2275 now.

> 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

        

Mime
View raw message