[HIVE-1836] Extend the CREATE DATABASE command with DBPROPERTIES

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.7.0
• Hadoop Flags: Reviewed
• Assignee: Ning Zhang
• Reporter: Ning Zhang
• Created: 07/Dec/10 02:05
• Updated: 17/Dec/11 00:01
• Resolved: 08/Dec/10 23:13

Description

We should be able to assign key-value pairs of properties to Hive databases.

The proposed syntax is similar to the CREATE TABLE and CREATE INDEX commands:

CREATE DATABASE <DB_NAME> WITH DBPROPERTIES ('key1' = 'value1', 'key2' = 'value2');

The

DESC DATABASE EXTENDED <DB_NAME>;

should be able to display the properties. (requires HIVE-1821)

Issue Links

• relates to: HIVE-1840 Support ALTER DATABASE to change database properties