[ https://issues.apache.org/jira/browse/HIVE-1836?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12968968#action_12968968 ]
Namit Jain commented on HIVE-1836: ---------------------------------- OK, I will file a follow-up task for 'alter database'. I think, the simple semantics can be: dont change the existing databases - the parameters are fixed at the time you select the database. I remermber, Oracle aso used to have the same semantics for a lot of security related issues - it is much simpler > Extend the CREATE DATABASE command with DBPROPERTIES > ---------------------------------------------------- > > Key: HIVE-1836 > URL: https://issues.apache.org/jira/browse/HIVE-1836 > Project: Hive > Issue Type: Sub-task > Reporter: Ning Zhang > Assignee: Ning Zhang > Attachments: HIVE-1836.patch > > > 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: > {code} > CREATE DATABASE <DB_NAME> WITH DBPROPERTIES ('key1' = 'value1', 'key2' = > 'value2'); > {code} > The > {code} > DESC DATABASE EXTENDED <DB_NAME>; > {code} > should be able to display the properties. (requires HIVE-1821) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.