[
https://issues.apache.org/jira/browse/HIVE-2032?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13015918#comment-13015918
]
Amareshwari Sriramadasu commented on HIVE-2032:
-----------------------------------------------
Use cases make sense. But, drop database would remove tables only from new
location.
Does anyone have the idea why alter Database currently allows to change only DB
properties? Namit/Ning?
bq.Post altering, new tables will be created under new location. Old tables'
have the fully qualified location in metadata and they should continue to work
as before.
Thiruvel, did you get a chance to test this? Because, your changes in patch
does not look complete. Changes should be propagated to PersistentManager
through ObjectStore.
> 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
