[jira] [Updated] (HIVE-22995) Add support for location for managed tables on database

["Naveen Gangam (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-22995?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Naveen Gangam updated HIVE-22995:
---------------------------------
    Fix Version/s: 4.0.0
       Resolution: Fixed
           Status: Resolved  (was: Patch Available)

Patch has been committed to the master. Thank you for the review [~samuelan] [~thejas]

> Add support for location for managed tables on database
> -------------------------------------------------------
>
>                 Key: HIVE-22995
>                 URL: https://issues.apache.org/jira/browse/HIVE-22995
>             Project: Hive
>          Issue Type: Improvement
>          Components: Hive
>    Affects Versions: 3.1.0
>            Reporter: Naveen Gangam
>            Assignee: Naveen Gangam
>            Priority: Major
>             Fix For: 4.0.0
>
>         Attachments: HIVE-22995.1.patch, HIVE-22995.10.patch, HIVE-22995.11.patch, HIVE-22995.12.patch, HIVE-22995.2.patch, HIVE-22995.3.patch, HIVE-22995.4.patch, HIVE-22995.5.patch, HIVE-22995.6.patch, HIVE-22995.7.patch, HIVE-22995.8.patch, HIVE-22995.9.patch, Hive Metastore Support for Tenant-based storage heirarchy.pdf
>
>
> 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.
> {code}
> 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;
> {code}



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