[jira] [Work logged] (HIVE-24175) Ease database managed location restrictions in HMS translation

["ASF GitHub Bot (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-24175?focusedWorklogId=569139&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-569139 ]

ASF GitHub Bot logged work on HIVE-24175:
-----------------------------------------

                Author: ASF GitHub Bot
            Created on: 19/Mar/21 21:10
            Start Date: 19/Mar/21 21:10
    Worklog Time Spent: 10m 
      Work Description: nrg4878 opened a new pull request #2094:
URL: https://github.com/apache/hive/pull/2094


   …Naveen Gangam)
   
   ### What changes were proposed in this pull request?
   With the introduction of a managedLocation and HMS translation layer, getDatabase() call always returns a managedlocation as well even if not set (defaults to managed warehouse dir). This might have been a bit ambitious as the preevent and postevents sent out as part of this create database DDL does not include this managed location. This path is added by the translation layer on a getDatabase() call. HMS DB store does not have a value either. So we are a bit inconsistent on this matter.
   
   ### Why are the changes needed?
   Address a bug fix.
   
   ### Does this PR introduce _any_ user-facing change?
   no
   
   ### How was this patch tested?
   Manually
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Issue Time Tracking
-------------------

            Worklog Id:     (was: 569139)
    Remaining Estimate: 0h
            Time Spent: 10m

> Ease database managed location restrictions in HMS translation
> --------------------------------------------------------------
>
>                 Key: HIVE-24175
>                 URL: https://issues.apache.org/jira/browse/HIVE-24175
>             Project: Hive
>          Issue Type: Sub-task
>    Affects Versions: 4.0.0
>            Reporter: Naveen Gangam
>            Assignee: Naveen Gangam
>            Priority: Major
>          Time Spent: 10m
>  Remaining Estimate: 0h
>
> Currently, HMS translation layer restricts the path of database's managed location to be within hive warehouse. so a getDatabase call will return a managedlocation path that adheres to this restriction regardless of what has been set in the HMS DB. This leads to issues like having inconsistent paths if hive-site.xml is not in sync across HMS and HS2 instances or even different HMS instances as each instance has a different version of warehouse root.



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