Add a Hive metastore component

If you have ACID enabled in Hive, ensure that the Run Compactor setting is enabled (set to True) on only one Hive metastore host.

In Ambari Web, browse to Services > Hive.
In Service Actions, click the + Add Hive Metastore option.
Choose the host on which to install the additional Hive Metastore; then click Confirm Add.

Ambari installs the component and reconfigures Hive to handle multiple Hive Metastore instances.

Review and confirm all recommended configuration changes.