hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Karen Coppage (Jira)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-24135) Drop database doesn't delete directory in managed location
Date Wed, 09 Sep 2020 12:35:00 GMT

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

Karen Coppage commented on HIVE-24135:
--------------------------------------

metastore.warehouse.dir needs to have a different value from metastore.warehouse.external.dir

> Drop database doesn't delete directory in managed location
> ----------------------------------------------------------
>
>                 Key: HIVE-24135
>                 URL: https://issues.apache.org/jira/browse/HIVE-24135
>             Project: Hive
>          Issue Type: Sub-task
>            Reporter: Karen Coppage
>            Assignee: Naveen Gangam
>            Priority: Major
>
> Repro:
>  say the default managed location is managed/hive and the default external location is
external/hive.
> {code:java}
> create database db1; -- creates: external/hive/db1.db
> create table db1.table1 (i int); -- creates: managed/hive/db1.db and  managed/hive/db1.db/table1
> drop database db1 cascade; -- removes : external/hive/db1.db and managed/hive/db1.db/table1
> {code}
> Problem: Directory managed/hive/db1.db remains.
> Since HIVE-22995, dbs have a managed (managedLocationUri) and an external location (locationUri).
I think the issue is that HiveMetaStore.HMSHandler#drop_database_core deletes only the db
directory in the external location.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Mime
View raw message