[HIVE-22995] Add support for location for managed tables on database

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.1.0
• Fix Version/s: 4.0.0-alpha-1
• Component/s: Hive
• Target Version/s: 4.0.0
• Assignee: Naveen Gangam
• Reporter: Naveen Gangam
• Created: 06/Mar/20 19:09
• Updated: 17/Nov/22 08:50
• Resolved: 03/Apr/20 06:49

Description

I have attached the initial spec to this jira.
Default location for database would be the external table base directory. Managed location can be optionally specified.

CREATE (DATABASE|SCHEMA) [IF NOT EXISTS] database_name
  [COMMENT database_comment]
  [LOCATION hdfs_path]
[MANAGEDLOCATION hdfs_path]
  [WITH DBPROPERTIES (property_name=property_value, ...)];

ALTER (DATABASE|SCHEMA) database_name SET 
MANAGEDLOCATION
 hdfs_path;

Issue Links

• breaks: HIVE-23697 Fix errors in the metastore upgrade script
• relates to: HIVE-24178 managedlocation is missing in SHOW CREATE DATABASE

Sub-Tasks

• Re-examine TestWarehouseExternalDir to see if it uses HMS translation.: Open
• "default" database locationUri should be external warehouse root.: Closed
• Flip the Warehouse.getDefaultTablePath() to return path from ext warehouse: Closed
• CTAS queries should use target's location for staging.: Closed
• create table like tabletype should match source tabletype and proper location: Open
• Fix errors in the metastore upgrade script: Closed
• Reject database creation if managedlocation is incorrect: Open
• MetastoreDirectSql.getDatabase() needs a space in the query: Closed
• Drop database doesn't delete directory in managed location: Closed
• getDatabase() to call translation code even if client has no capabilities: Closed