I've enabled High Availabilty for Hive, as per HW doc I need to assign run compactor property on only one particular Hive metastore.
How can I set this up?
This can be achieved using config groups in Ambari.
For disabling compaction follow https://docs.cloudera.com/HDPDocuments/HDP3/HDP-3.1.5/managing-hive/content/hive_disable_hive_compac...
We discourage using this mechanism of initiating compaction for one metastore.
Is this the way to set it up @asish
I've created a Host config group 'Run Compactor' with 1 HMS host and enabled Run Compactor property for that host and disabled the Run compactor property in the "default' group.