Valeriy created HIVE-21652:
------------------------------
Summary: 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
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)
