Mandatory HDP policy-level properties

You must set a number of policy-level properties in REPL DUMP command on the HDP cluster. Put the property after the WITH clause of the command.

Table 1.
Property	Description	Required Value
hive.repl.dump.version	REPL DUMP format version. - Use 2 for HDP-to-CDP Private Cloud Base replication. - Use 1 for HDP to HDP replication.	2
hive.repl.rootdir	Staging location path. Enter the same path for REPL DUMP and REPL LOAD commands.	[*HDFS path] Note:* Use the same parameter value in REPL DUMP and REPL LOAD commands.
hive.repl.include.external.tables	Include external tables for replication.	true
hive.repl.dump.metadata.only.for .external.table	Includes only external table metadata for replication.	false
hive.repl.replica.external.table.b ase.dir	Fully qualified base directory on the target warehouse to store external tables. The directory path is prefixed to the source external table path on the target cluster.	[*HDFS path] Note:* Use the same parameter value in REPL DUMP and REPL LOAD commands.
hive.repl.ha.datapath.replace.re mote.nameservice	Set to true when the following are true: - HDFS is HA-enabled - Both the source and target clusters are configured with the same nameservice name.	See Description before you configure this option.
hive.repl.ha.datapath.replace.re mote.nameservice.name	Provides a reference to the nameservice on the remote (target) cluster when HDFS is HA-enabled and both source and target clusters are configured with the same nameservice name.	[remote nameservice name] Note: Use the same parameter value in REPL,DUMP and REPL LOAD commands.

hive.repl.ha.datapath.replace.re mote.nameservice.name value requirements

Ensure the value of hive.repl.ha.datapath.replace.re mote.nameservice.name is different from the nameservice name on the local (source) cluster. For example, if the clusters use the nameservice name ns, then use a different property value. For example, ‘hive.repl.ha.datapath.replace.remote.nameserv ice.name’ = ‘nsRemote’.