hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ning Zhang (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-2032) create database does not honour warehouse.dir in dbproperties
Date Fri, 08 Apr 2011 04:51:06 GMT

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

Ning Zhang commented on HIVE-2032:
----------------------------------

Thiruvel, HIVE-1820 (actually the subtask of it HIVE-1836) is not intended to define the database
LOCATION. The database metastore schema already contains a LOCATION field, but it was not
currently exposed through the CREATE DATABASE syntax. That's what HIVE-1537 is about to solve.
HIVE-1836 is to introduce dbproperties of generic key-value pairs. The dbproperties can be
used/interpreted by application-level pre-execution hooks. We currently do not require the
warehouse.dir (if it is one of the keys) must be consistent with the LOCATION field, and I
think probably we don't need to keep 2 piece of information with the same semantics. 

If you want to change the database location URL I think probably a better way is to change
the CREATE DATABASE syntax to add location (HIVE-1537) and any table created under that database
should honor the database location property. What do you think?


> 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

Mime
View raw message