You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Marcel Kornacker (JIRA)" <ji...@apache.org> on 2010/12/20 23:21:01 UTC

[jira] Created: (HIVE-1856) Implement DROP TABLE/VIEW ... IF EXISTS

Implement DROP TABLE/VIEW ... IF EXISTS 
----------------------------------------

                 Key: HIVE-1856
                 URL: https://issues.apache.org/jira/browse/HIVE-1856
             Project: Hive
          Issue Type: New Feature
    Affects Versions: 0.7.0
            Reporter: Marcel Kornacker
            Assignee: Marcel Kornacker


This issue combines issues HIVE-1550/1165/1542/1551:
- augment DROP TABLE/VIEW with IF EXISTS
- signal an error if the table/view doesn't exist and IF EXISTS wasn't specified
- introduce a flag in the configuration that allows you to turn off the new behavior

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (HIVE-1856) Implement DROP TABLE/VIEW ... IF EXISTS

Posted by "John Sichi (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-1856?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12973809#action_12973809 ] 

John Sichi commented on HIVE-1856:
----------------------------------

+1.  Will commit when tests pass.

Note for next time:  for patch updates, our convention is to number them like HIVE-1856.1.patch, HIVE-1856.2.patch, etc.  And then click the "Submit Patch" button again when a new one is uploaded; this makes sure it gets back into the review queue.


> Implement DROP TABLE/VIEW ... IF EXISTS 
> ----------------------------------------
>
>                 Key: HIVE-1856
>                 URL: https://issues.apache.org/jira/browse/HIVE-1856
>             Project: Hive
>          Issue Type: New Feature
>    Affects Versions: 0.7.0
>            Reporter: Marcel Kornacker
>            Assignee: Marcel Kornacker
>         Attachments: hive-1856.patch, hive-1856.patch
>
>
> This issue combines issues HIVE-1550/1165/1542/1551:
> - augment DROP TABLE/VIEW with IF EXISTS
> - signal an error if the table/view doesn't exist and IF EXISTS wasn't specified
> - introduce a flag in the configuration that allows you to turn off the new behavior

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (HIVE-1856) Implement DROP TABLE/VIEW ... IF EXISTS

Posted by "John Sichi (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-1856?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

John Sichi updated HIVE-1856:
-----------------------------

    Status: Open  (was: Patch Available)

Review comments in

https://reviews.apache.org/r/188/

Note that there are also DROP commands for databases, indexes, partitions, and temporary functions.  This config property should cover those too, so we should either address those as well in this patch, or open a followup JIRA.


> Implement DROP TABLE/VIEW ... IF EXISTS 
> ----------------------------------------
>
>                 Key: HIVE-1856
>                 URL: https://issues.apache.org/jira/browse/HIVE-1856
>             Project: Hive
>          Issue Type: New Feature
>    Affects Versions: 0.7.0
>            Reporter: Marcel Kornacker
>            Assignee: Marcel Kornacker
>         Attachments: hive-1856.patch
>
>
> This issue combines issues HIVE-1550/1165/1542/1551:
> - augment DROP TABLE/VIEW with IF EXISTS
> - signal an error if the table/view doesn't exist and IF EXISTS wasn't specified
> - introduce a flag in the configuration that allows you to turn off the new behavior

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Resolved: (HIVE-1856) Implement DROP TABLE/VIEW ... IF EXISTS

Posted by "John Sichi (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-1856?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

John Sichi resolved HIVE-1856.
------------------------------

       Resolution: Fixed
    Fix Version/s: 0.7.0
     Release Note: Backwards-compatible DROP behavior is controlled via new configuration parameter hive.exec.drop.ignorenonexistent
     Hadoop Flags: [Reviewed]

Committed.  Thanks Marcel!


> Implement DROP TABLE/VIEW ... IF EXISTS 
> ----------------------------------------
>
>                 Key: HIVE-1856
>                 URL: https://issues.apache.org/jira/browse/HIVE-1856
>             Project: Hive
>          Issue Type: New Feature
>    Affects Versions: 0.7.0
>            Reporter: Marcel Kornacker
>            Assignee: Marcel Kornacker
>             Fix For: 0.7.0
>
>         Attachments: hive-1856.patch, hive-1856.patch
>
>
> This issue combines issues HIVE-1550/1165/1542/1551:
> - augment DROP TABLE/VIEW with IF EXISTS
> - signal an error if the table/view doesn't exist and IF EXISTS wasn't specified
> - introduce a flag in the configuration that allows you to turn off the new behavior

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (HIVE-1856) Implement DROP TABLE/VIEW ... IF EXISTS

Posted by "Jeff Hammerbacher (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-1856?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12973998#action_12973998 ] 

Jeff Hammerbacher commented on HIVE-1856:
-----------------------------------------

John: added your comments about patch updates to http://wiki.apache.org/hadoop/Hive/HowToContribute#Updating_a_patch

> Implement DROP TABLE/VIEW ... IF EXISTS 
> ----------------------------------------
>
>                 Key: HIVE-1856
>                 URL: https://issues.apache.org/jira/browse/HIVE-1856
>             Project: Hive
>          Issue Type: New Feature
>    Affects Versions: 0.7.0
>            Reporter: Marcel Kornacker
>            Assignee: Marcel Kornacker
>             Fix For: 0.7.0
>
>         Attachments: hive-1856.patch, hive-1856.patch
>
>
> This issue combines issues HIVE-1550/1165/1542/1551:
> - augment DROP TABLE/VIEW with IF EXISTS
> - signal an error if the table/view doesn't exist and IF EXISTS wasn't specified
> - introduce a flag in the configuration that allows you to turn off the new behavior

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (HIVE-1856) Implement DROP TABLE/VIEW ... IF EXISTS

Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-1856?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Carl Steinbach updated HIVE-1856:
---------------------------------

    Component/s: Query Processor
                 Metastore

> Implement DROP TABLE/VIEW ... IF EXISTS 
> ----------------------------------------
>
>                 Key: HIVE-1856
>                 URL: https://issues.apache.org/jira/browse/HIVE-1856
>             Project: Hive
>          Issue Type: New Feature
>          Components: Metastore, Query Processor
>    Affects Versions: 0.7.0
>            Reporter: Marcel Kornacker
>            Assignee: Marcel Kornacker
>             Fix For: 0.7.0
>
>         Attachments: hive-1856.patch, hive-1856.patch
>
>
> This issue combines issues HIVE-1550/1165/1542/1551:
> - augment DROP TABLE/VIEW with IF EXISTS
> - signal an error if the table/view doesn't exist and IF EXISTS wasn't specified
> - introduce a flag in the configuration that allows you to turn off the new behavior

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (HIVE-1856) Implement DROP TABLE/VIEW ... IF EXISTS

Posted by "Marcel Kornacker (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-1856?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Marcel Kornacker updated HIVE-1856:
-----------------------------------

    Attachment: hive-1856.patch

> Implement DROP TABLE/VIEW ... IF EXISTS 
> ----------------------------------------
>
>                 Key: HIVE-1856
>                 URL: https://issues.apache.org/jira/browse/HIVE-1856
>             Project: Hive
>          Issue Type: New Feature
>    Affects Versions: 0.7.0
>            Reporter: Marcel Kornacker
>            Assignee: Marcel Kornacker
>         Attachments: hive-1856.patch
>
>
> This issue combines issues HIVE-1550/1165/1542/1551:
> - augment DROP TABLE/VIEW with IF EXISTS
> - signal an error if the table/view doesn't exist and IF EXISTS wasn't specified
> - introduce a flag in the configuration that allows you to turn off the new behavior

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (HIVE-1856) Implement DROP TABLE/VIEW ... IF EXISTS

Posted by "Marcel Kornacker (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-1856?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Marcel Kornacker updated HIVE-1856:
-----------------------------------

    Attachment: hive-1856.patch

> Implement DROP TABLE/VIEW ... IF EXISTS 
> ----------------------------------------
>
>                 Key: HIVE-1856
>                 URL: https://issues.apache.org/jira/browse/HIVE-1856
>             Project: Hive
>          Issue Type: New Feature
>    Affects Versions: 0.7.0
>            Reporter: Marcel Kornacker
>            Assignee: Marcel Kornacker
>         Attachments: hive-1856.patch, hive-1856.patch
>
>
> This issue combines issues HIVE-1550/1165/1542/1551:
> - augment DROP TABLE/VIEW with IF EXISTS
> - signal an error if the table/view doesn't exist and IF EXISTS wasn't specified
> - introduce a flag in the configuration that allows you to turn off the new behavior

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (HIVE-1856) Implement DROP TABLE/VIEW ... IF EXISTS

Posted by "Marcel Kornacker (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-1856?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Marcel Kornacker updated HIVE-1856:
-----------------------------------

    Status: Patch Available  (was: Open)

> Implement DROP TABLE/VIEW ... IF EXISTS 
> ----------------------------------------
>
>                 Key: HIVE-1856
>                 URL: https://issues.apache.org/jira/browse/HIVE-1856
>             Project: Hive
>          Issue Type: New Feature
>    Affects Versions: 0.7.0
>            Reporter: Marcel Kornacker
>            Assignee: Marcel Kornacker
>         Attachments: hive-1856.patch
>
>
> This issue combines issues HIVE-1550/1165/1542/1551:
> - augment DROP TABLE/VIEW with IF EXISTS
> - signal an error if the table/view doesn't exist and IF EXISTS wasn't specified
> - introduce a flag in the configuration that allows you to turn off the new behavior

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.