Creating Hive ACID table replication policy

You can create a Hive ACID replication policy after you set up the environment and configure the required parameters.

Verify whether the prerequisites are met. For more information, see Prepare to create Hive ACID table replication policies.
  1. Go to the Replication > Replication Policies page in the Cloudera Manager for the target cluster where the peer is set up.
  2. Click Create Replication Policy.
  3. Select Hive ACID Table Replication Policy.
    The following sample image shows the Hive ACID Table Replication Policy option on the Replication Policies page in Cloudera Manager:
    The image shows the Hive ACID Table Replication Policy option on the  Replication Policies page in Cloudera Manager.
    The Create Hive ACID Table Replication Policy wizard appears.
  4. In the General tab, configure the following options:
    Option Action to perform
    Policy Name Enter a unique name for the replication policy.
    Source Choose the source cluster.
    Destination Choose the target cluster.
    Destination Staging Path Enter a valid path to the staging location. The path must have the required permissions for the hive user. For example: /user/hive/data.

    Hive ACID table replication uses a common staging location on the source or target cluster. To set the staging location path, use the configuration parameter hive.repl.rootdir. The REPL DUMP command dumps data in the staging location in the source cluster. The REPL LOAD command reads the data from the staging location. The REPL DUMP command runs in the source cluster and the REPL LOAD command runs in the target cluster.

    Source Database Enter the source database name.
    Schedule Schedule the replication job as necessary. The Hive ACID table replication policy uses the Hive scheduler to schedule the replication policies.
    You can choose the following schedule options:
    • Every - Choose an interval. The schedule starts at the next exact interval based on the server time. If you want to start it immediately, issue a Run Now operation.

      For example, if you are in California and the destination cluster is in the Europe (Frankfurt) region, the schedule is set based on the server time, that is, Frankfurt local time.

    • Unix Cron Expression - Enter a valid Unix cron expression.

      You can generate the Unix cron expression in the following page, and then use it in the Create Hive ACID Table Replication Policy wizard:

      https://www.freeformatter.com/cron-expression-generator-quartz.html

      For example, you can use 0 */30 * ? * * to schedule the policy to run every 30 minutes, 0 0 */4 ? * * to schedule the run for every 4 hours, or 0 0 0 * * ? every day at midnight.
    Run as Username Enter hive.
  5. Click the Resources tab to configure the following options:
    Option Description
    Scheduler Pool (Optional) Enter the name of a resource pool.

    The value you enter is used by the MapReduce Service when Cloudera Manager runs the MapReduce job for the replication. You can use one of the following property:

    • MapReduce – Fair scheduler: mapred.fairscheduler.pool
    • MapReduce – Capacity scheduler: queue.name
    • YARN – mapreduce.job.queuename
    Maximum Number of Copy Mappers Enter the maximum number of simultaneous copy mappers for DistCp. The default value is 20.
    Maximum Bandwidth per Copy Mapper Enter the maximum bandwidth for each mapper in megabytes per second. The default is 100 MB.
  6. Select the Advanced tab to configure the following options:
    Option Description
    Policy Description (Optional). Enter a brief description for the replication policy.
    Overrides Enter key-value pairs to override parameters for Hive ACID table replication configuration.

    For example, when you use HA-based clusters, you can enter the relevant key-value pairs. During the replication process, the Replication Manager overrides the key-values pairs. You can also pass the DistCp argument.

  7. Click Save to run the Hive ACID table replication policy.
When a non-recoverable error appears with the FAILED_ADMIN status for a replication job, perform the following steps to fix the error:
  1. Go to the error log path.
  2. Search for the file named _non_recoverable.
  3. Check the error stack that is printed in the _non_recoverable file.
  4. Fix the error.
  5. Delete the _non_recoverable file. For the next replication jobs in the policy to function normally, the _non_recoverable file must be deleted.