Changing the Hive warehouse location

You need to know how to use Cloudera Manager to change the location of the Hive warehouse.

You use the Hive Metastore Action menu in Cloudera Manager, and navigate to one of the following menu items in the first step below.

• Hive > Action Menu > Create Hive Warehouse Directory
• Hive > Action Menu > Create Hive Warehouse External Directory

1. Set up directories for the Hive warehouse directory and Hive warehouse external directory from Cloudera Manager Actions.

   

2. In Cloudera Manager, click Clusters > Hive (the Hive Metastore service) > Configuration, and change the hive.metastore.warehouse.dir property value to the path you specified for the new Hive warehouse directory.
3. Change the hive.metastore.warehouse.external.dir property value to the path you specified for the Hive warehouse external directory.
4. Configure Ranger policies or set up ACL permissions to access the directories.