[jira] [Created] (HIVE-21652) Extend ALTER TABLE DROP PARTITION syntax to use regular expressions

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

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)