Locating Hive tables and changing the location
You need to know where Hive stores tables on HDFS and how to change the warehouse location after installing the service.
Managed tables reside in the managed tablespace, which only Hive can access. By default, Hive assumes external tables reside in the external tablespace.
To determine the managed or external table type, you can run the DESCRIBE EXTENDED table_name command.
You need to set HDFS policies to access external tables in Ranger, or set up HDFS ACLs.The capability to change the location of the Hive warehouse is intended for use immediately after installing the service. You can change the location of the warehouse using the Hive Metastore Action menu in Cloudera Manager as described in the following steps:
- In Cloudera Manager, click .
In Cloudera Manager, click
hive.metastore.warehouse.dirproperty value to the path for the new Hive warehouse directory. , and change the
- Click .
hive.metastore.warehouse.external.dirproperty value to the path for the Hive warehouse external directory.
- Configure Ranger policies or set up ACL permissions to access the directories.