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, modifyhive_conf_dir
to point to the directory containinghive-site.xml
file.The Hive data is stored in HDFS, typically under
/user/hive/warehouse
(or any path as specified by thehive.metastore.warehouse.dir
property in thehive-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).