4. Configure Hive

You can use the Hue Beeswax application to integrate with Hive to query your data. Verify that you complete the following checks for successful integration with Hive:

In the /etc/hue/conf/hue.ini file, modify hive_conf_dir to point to the directory containing hive-site.xml file.
The Hive data is stored in HDFS, typically under /user/hive/warehouse (or any path as specified by the hive.metastore.warehouse.dir property in the hive-site.xml file).
Ensure that this location exists and is world-writable (1777) by the users responsible for creating tables.
Hive extensively uses the /tmp directory (on the local file system).
Ensure that the hive.security.authorization.manager class is visible to Hue.
For example, if
hive.security.authorization.manager=org.apache.hcatalog.security.HdfsAuthorizationProvider
ensure that you execute the following command on the Hive metastore host machine:
```
ln -s /usr/lib/hcatalog/share/hcatalog/hcatalog-core.jar $HIVE_HOME
```
where $HIVE_HOME by default points to /usr/lib/hive/lib/.

Legal notices