HIVE-28350: Drop remote database should succeed deleting data under d…

[saihemanth-cloudera]

…b location

What changes were proposed in this pull request?

Setting remote database location and managed location

Why are the changes needed?

Otherwise drop remote database is not successful

Does this PR introduce any user-facing change?

No

Is the change a dependency upgrade?

No

How was this patch tested?

Local Cluster