[
https://issues.apache.org/jira/browse/HIVE-804?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12749032#action_12749032
]
Prasad Chakka commented on HIVE-804:
------------------------------------
* Do we ever want to support arbitrary partition key/vals instead of just a
prefix? What about range queries?
# for dropping partitions that matches a given prefix,
## 2A is good enough
# for dropping partitions whose keys match the given key/vals
## partition key/values are stored in model.Partition.values attribute which is
a list. So you can possibly generate the query based on which partion key is
needed.
# for dropping ranges
## if the range is applied on a prefix, then 2A can be used otherwise need to
bring in all partitions
IMO, the trickier problem is to make sure the partition data directory(ies)
gets deleted atomically along with the partitions. Even for a prefix, the
partition data directories can be different based on how the partition is
created. we need to get those semantics correctly.
> 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.
