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

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

     [ 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)