[
https://issues.apache.org/jira/browse/HIVE-2032?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13015818#comment-13015818
]
Thiruvel Thirumoolan commented on HIVE-2032:
--------------------------------------------
@Amareshwari
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.
The reasons I went with alter location are:
1. Allow migration to happen if one would like to reorganize or if quota runs
out. Not sure how many folks have this situation.
2. One can migrate new tables to another DFS cluster (existing cluster becoming
full).
3. One can migrate between file systems if they have sufficient use cases.
Do you think these are valid use cases?
> 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
