[
https://issues.apache.org/jira/browse/HIVE-21652?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16826778#comment-16826778
]
Akshay Hazari commented on HIVE-21652:
--------------------------------------
Seem
> Extend ALTER TABLE DROP PARTITION syntax to use regular expressions
> -------------------------------------------------------------------
>
> Key: HIVE-21652
> URL: https://issues.apache.org/jira/browse/HIVE-21652
> Project: Hive
> Issue Type: Wish
> Reporter: Valeriy
> Priority: Minor
>
> To drop a partition from a Hive table, this works:
> ALTER TABLE foo DROP PARTITION(ds < 'date')
> we can use all of the comparators, < > <= >= <> = !=
> as per https://issues.apache.org/jira/browse/HIVE-2908
> But it does not help to drop multiple partitions using some template, like
> this
> {code:java}
> ALTER TABLE foo DROP PARTITION(date not rlike
> '(19|20)[0-9]{2}-(0[1-9]|1[012])-(0[1-9]|[12][0-9]|3[01])');{code}
> Please add feature like this, to make it possible to use regexp or LIKE.
> Impala has LIKE feature:
> https://www.cloudera.com/documentation/enterprise/5-15-x/topics/impala_alter_table.html
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
