Hi, I want to replicate the Hive metastore to create a separate instance (for example, replicate the prod metadata to create a dev metastore).
I'm using Hive version 3.1.2 and it only supports managed table replication and lacks external table replication. I want to try and get external tables also replicate on Hive 3. A couple of questions here: 1. I see the Pull request https://github.com/apache/hive/pull/506/files for external table replication on Hive 4. Is it viable to cherry-pick it to Hive 3, and is this something that has been tried out? 2. Also, I only want to replicate the metadata and not the data itself. 3. The replication commands seem to have changed with Hive 4, and I'm unable to find the new commands (there's no documentation), the latest documentation seen is https://cwiki.apache.org/confluence/display/Hive/HiveReplicationv2Development which does not cover the external tables. Kindly guide me on the above. Thanks, Bharath