hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Adam Kramer (Updated) (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-2826) ALTER VIEW ADD (IF NOT EXISTS) PARTITION syntax is bad.
Date Tue, 10 Apr 2012 08:04:15 GMT

     [ https://issues.apache.org/jira/browse/HIVE-2826?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Adam Kramer updated HIVE-2826:
------------------------------

    Description: 
The syntax, ALTER TABLE x ADD IF NOT EXISTS PARTITION, puts the "IF NOT EXISTS" before the
subject of the statement. Not only is this weird grammar, but it is also inconsistent with
other uses of "IF NOT EXISTS", for example, "CREATE TABLE IF NOT EXISTS" and "DROP TABLE IF
EXISTS".

It would be a minor improvement to align the syntaxes.


  was:
Support for ALTER TABLE x ADD IF NOT EXISTS PARTITION was added in HIVE-1106. The same semantics
should be supported for ALTER VIEW.

WAS:
When trying to add a partition, if the partition already exists, we shouldn't necessarily
cause the job to fail...just like we have CREATE TABLE IF NOT EXISTS and DROP TABLE IF EXISTS,
we should have ALTER TABLE foo ADD PARTITION IF NOT EXISTS (ds=whatever).

Ditto for ALTER VIEW.

        Summary: ALTER VIEW ADD (IF NOT EXISTS) PARTITION syntax is bad.  (was: ALTER VIEW
ADD PARTITION needs IF NOT EXISTS.)
    
> ALTER VIEW ADD (IF NOT EXISTS) PARTITION syntax is bad.
> -------------------------------------------------------
>
>                 Key: HIVE-2826
>                 URL: https://issues.apache.org/jira/browse/HIVE-2826
>             Project: Hive
>          Issue Type: Improvement
>            Reporter: Adam Kramer
>
> The syntax, ALTER TABLE x ADD IF NOT EXISTS PARTITION, puts the "IF NOT EXISTS" before
the subject of the statement. Not only is this weird grammar, but it is also inconsistent
with other uses of "IF NOT EXISTS", for example, "CREATE TABLE IF NOT EXISTS" and "DROP TABLE
IF EXISTS".
> It would be a minor improvement to align the syntaxes.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message