[jira] Commented: (HIVE-804) Support deletion of partitions based on a prefix partition spefication

["Zheng Shao (JIRA)" <ji...@apache.org>]

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

Zheng Shao commented on HIVE-804:
---------------------------------

There are 2 questions:

1. Where to match the partitions against the prefix and do the deletion:
A. In DDLTask
B. In ObjectStore

B is better not only because of efficiency but also because other clients can share this functionality.

2. How to match the partitions against the prefix.
A. Get the name of the partition, then convert the String name to Map<String,String>, then match against the prefix (also Map<String,String>). If every entry matches (there can be misses) then it's a match.
B. Retreive the whole partition object.

A is much more efficient.



> Support deletion of partitions based on a prefix partition spefication
> ----------------------------------------------------------------------
>
>                 Key: HIVE-804
>                 URL: https://issues.apache.org/jira/browse/HIVE-804
>             Project: Hadoop Hive
>          Issue Type: New Feature
>            Reporter: Zheng Shao
>
> Sometimes users create partitions like (date='...', time='...'). It is useful if user can delete all the partitions of the same day (and different time) with a single command:
> {code}
> ALTER TABLE test DROP PARTITION (date='2009-08-26');
> {code}

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.