cloudera-labs / hms-mirror

"hms-mirror" is a utility used to bridge the gap between two clusters and migrate hive metadata.
Apache License 2.0
13 stars 8 forks source link

Enhance RIGHT DB actions for clusters where user has limited rights but DB prepared for mirroring #146

Closed jkovacs-hwx closed 1 month ago

jkovacs-hwx commented 2 months ago

In case if user has limited DB level permissions - like can work with tables but can't change DB attributes - some actions/statements needs to be configurable for successful mirroring:

jkovacs-hwx commented 2 months ago

The DB location change could cause issues if altering location is skipped and tables would be mirrored to new location, but then this could be more complex like:

In these cases I think the user needs to set up proper 'relocation' configuration rather expect hms-mirror to handle automatic mapping. The only auto-mapping could be changing managed table locations from custom locations to the strict MANAGEDLOCATION in newer hive versions