hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Teddy Choi (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-4847) add rename database functionality
Date Thu, 08 Aug 2013 06:44:57 GMT

    [ https://issues.apache.org/jira/browse/HIVE-4847?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13733205#comment-13733205
] 

Teddy Choi commented on HIVE-4847:
----------------------------------

I wrote some code to modify a MDatabase name on ObjectStore, and it seemed like working properly.
But it had a serious bug. When a user creates and manipulates a new database and tables with
old names, data gets corrupted. Because old tables and new tables used same data directories.
It was more complex than I thought first.

I will modify the code to move directories containing actual data. There will be some exceptional
cases; such as there already exist directories with same names, or external tables. When Hive
meets those cases, it will throw an error to prevent data corruption.
                
> add rename database functionality
> ---------------------------------
>
>                 Key: HIVE-4847
>                 URL: https://issues.apache.org/jira/browse/HIVE-4847
>             Project: Hive
>          Issue Type: New Feature
>    Affects Versions: 0.11.0
>            Reporter: Greg Rahn
>            Assignee: Teddy Choi
>            Priority: Minor
>
> There seems to be no way to rename a database in Hive, functionality to do so would be
nice.
> Proposed syntax:
> ALTER DATABASE dbname RENAME TO newdbname;

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message