You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Csaba Ringhofer (Jira)" <ji...@apache.org> on 2020/09/18 09:34:00 UTC
[jira] [Created] (HIVE-24178) managedlocation is missing in SHOW
CREATE DATABASE
Csaba Ringhofer created HIVE-24178:
--------------------------------------
Summary: managedlocation is missing in SHOW CREATE DATABASE
Key: HIVE-24178
URL: https://issues.apache.org/jira/browse/HIVE-24178
Project: Hive
Issue Type: Bug
Reporter: Csaba Ringhofer
The output of SHOW CREATE DATABASE contains location, but doesn't contain managed location, so the database it would create would be actually different.
To reproduce:
create database db1 location "/test-warehouse/a" managedlocation "test-warehouse/b";
show create database db1;
result:
+----------------------------------------------+
| createdb_stmt |
+----------------------------------------------+
| CREATE DATABASE `db1` |
| LOCATION |
| 'hdfs://localhost:20500/test-warehouse/a' |
+----------------------------------------------+
--
This message was sent by Atlassian Jira
(v8.3.4#803005)