You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Andy Zhang (Jira)" <ji...@apache.org> on 2020/07/22 02:27: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=17162433#comment-17162433 ]
Andy Zhang commented on HIVE-21820:
-----------------------------------
i think if you use the below command to create new database:
create database abc location "/users/hive/warehouse/project_name/abc.db";
when you delete database abc,the entire project_name directory will not delete from HDFS,only delete abc.db from HDFS
> 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
> Affects Versions: 1.2.1
> 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
(v8.3.4#803005)