[IMPALA-462] ALTER DATABASE support to rename or move database

• Type: New Feature
• Status: Reopened
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: Impala 1.1, Impala 2.3.0
• Fix Version/s: Product Backlog
• Component/s: Catalog
• Labels: ramp-up
• Target Version: Product Backlog
• Assignee: Unassigned
• Reporter: John Russell
• Created: 12/Jul/13 22:36
• Updated: 23/Dec/20 22:27

Description

I suggest adding an ALTER DATABASE statement, for completeness and future expansion.
Currently, Hive has ALTER DATABASE that AFAICT only allows a SET clause to change properties.

One logical syntax / use case for an Impala ALTER DATABASE would be:

ALTER DATABASE old_name RENAME TO new_name;

(OK to disallow for the DEFAULT database or the currently USEd database.)

Issue Links

• is related to: IMPALA-10172 Support Hive metastore managed locations for databases
• relates to: HIVE-4847 add rename database functionality
• relates to: HIVE-8472 Add ALTER DATABASE SET LOCATION