Changing the Hive warehouse location

You can change the location of the warehouse using the Hive Metastore Action menu in Cloudera Manager.

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 access control list (ACL) permissions to access the directories.