You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Miklos Gergely (Jira)" <ji...@apache.org> on 2020/10/04 08:25:00 UTC
[jira] [Resolved] (HIVE-24178) managedlocation is missing in SHOW
CREATE DATABASE
[ https://issues.apache.org/jira/browse/HIVE-24178?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Miklos Gergely resolved HIVE-24178.
-----------------------------------
Resolution: Fixed
> 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
> Assignee: Miklos Gergely
> Priority: Major
> Labels: pull-request-available
> Time Spent: 20m
> Remaining Estimate: 0h
>
> 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)