[ https://issues.apache.org/jira/browse/HIVE-2032?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13017363#comment-13017363 ]
Amareshwari Sriramadasu commented on HIVE-2032: ----------------------------------------------- I agree with Ning. There should not be two piece of information with same semantics. Location should be added to create database and alter database if it can be altered. Also, We should document that dbproperties are interpreted at application level. > create database does not honour warehouse.dir in dbproperties > ------------------------------------------------------------- > > Key: HIVE-2032 > URL: https://issues.apache.org/jira/browse/HIVE-2032 > Project: Hive > Issue Type: Bug > Components: Clients > Affects Versions: 0.7.0, 0.8.0 > Reporter: Thiruvel Thirumoolan > Assignee: Thiruvel Thirumoolan > Fix For: 0.8.0 > > Attachments: DatabaseLocation.patch > > > # create database db with dbproperties ('hive.metastore.warehouse.dir' = > 'loc'); > The above command does not set location of 'db' to 'loc'. It instead creates > 'db.db' under the warehouse directory configured in hive-site.xml of CLI. > Looks conflicting with HIVE-1820's expectation. If scratch dir is specified > here, that is honoured. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira