Ease database managed location restrictions in HMS translation

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.