hive-dev mailing list archives

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

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

John Sichi commented on HIVE-2219:
----------------------------------

Since this patch already got committed, I would recommend opening a new JIRA issue to amend
it.

> 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