[
https://issues.apache.org/jira/browse/HIVE-21652?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Akshay Hazari updated HIVE-21652:
---------------------------------
Comment: was deleted
(was: 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)
