[
https://issues.apache.org/jira/browse/HIVE-4847?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15185403#comment-15185403
]
Alan Gates commented on HIVE-4847:
----------------------------------
I agree that there are parts of the system that this can wreak havoc with, such
as replication and ACID. But it seems all of the same arguments apply to
renaming a table, which Hive supports.
Rather than saying we won't apply the patch because of this we should say we
won't apply the patch until it addresses these areas. Beyond just ACID and
replication the HBase metastore (in 2.0 only) will also be impacted by this,
since it uses the db name as the key for storing databases, tables, and
partitions.
> 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
> Attachments: HIVE-4847.1.patch.txt, HIVE-4847.2.patch.txt
>
>
> 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 was sent by Atlassian JIRA
(v6.3.4#6332)
