You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Shawn Weeks (JIRA)" <ji...@apache.org> on 2019/06/02 14:30:00 UTC
[jira] [Commented] (HIVE-21820) drop database command flushing
other data outside db folder
[ https://issues.apache.org/jira/browse/HIVE-21820?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16853983#comment-16853983 ]
Shawn Weeks commented on HIVE-21820:
------------------------------------
I think this expected behavior. You have to include the abc.db folder in the location if you wanted it created there. The location parameter is the entire path for the database not the starting path.
> drop database command flushing other data outside db folder
> -----------------------------------------------------------
>
> Key: HIVE-21820
> URL: https://issues.apache.org/jira/browse/HIVE-21820
> Project: Hive
> Issue Type: Bug
> Reporter: Neeraj Maheshwari
> Priority: Blocker
>
> On running the below command to create new database:
> *create database abc location /users/hive/warehouse/project_name/;*
> here expected is, this command should create a new db folder named abc.db under project_name directory, but with hive version 1.2.1000.2.6.3.0-235 its not creating abc.db folder.
>
> And on running command *drop database abc;* the entire project_name directory got deleted from HDFS. So here drop command rather than dropping just one db it deleted whole directory and just retained meta informations in hive metastore for other dbs present in project_name directory.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)