Minimum Required Role: Configurator (also provided by Cluster Administrator, Full Administrator)

1. Go to the Hive service.
2. If you have a secure cluster, enable the Hive token store. Non-secure clusters can skip this step.

   To apply this configuration property to other role groups as needed, edit the value for the appropriate role group. See Modifying Configuration Properties Using Cloudera Manager.

   1. Click the Configuration tab.
   2. Select Scope > Hive Metastore Server.
   3. Select Category > Advanced.
   4. Locate the Hive Metastore Delegation Token Store property or search for it by typing its name In the Search box.
   5. Select org.apache.hadoop.hive.thrift.DBTokenStore.
   6. Click Save Changes to commit the changes.
3. Click the Instances tab.
4. Click Add Role Instances.
5. Click the text field under Hive Metastore Server.
6. Check the box by the host on which to run the additional metastore and click OK.
7. Click Continue and click Finish.
8. Check the box by the new Hive Metastore Server role.
9. Select Actions for Selected > Start, and click Start to confirm.
10. Click Close and click to display the stale configurations page.
11. Click Restart Stale Services and click Restart Now.
12. Click Finish after the cluster finishes restarting.