[ 
https://issues.apache.org/jira/browse/HIVE-2032?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13014458#comment-13014458
 ] 

Amareshwari Sriramadasu commented on HIVE-2032:
-----------------------------------------------

I see changes for alter Database also to change the location URI. What are 
semantics of alter database for changing location uri? Is it going to create 
the tables under the new location after altering? If so, what happens to 
earlier tables. I see that location uri is accessed only in create db and drop 
db. So, I think we should not allow altering the location uri. Shall we throw 
an error if it altered?

Changes for create DB look fine. Can you update 
TestHiveMetaStore.testDatabase() to test the same?

> 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

Reply via email to