[HIVE-24178] managedlocation is missing in SHOW CREATE DATABASE

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Labels: pull-request-available
• Assignee: Miklos Gergely
• Reporter: Csaba Ringhofer
• Created: 18/Sep/20 09:33
• Updated: 04/Oct/20 08:24
• Resolved: 04/Oct/20 08:24

Description

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'

----------------------------------------------

Issue Links

• is related to: HIVE-22995 Add support for location for managed tables on database
• links to: GitHub Pull Request #1508