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:

  1. In the /etc/hue/conf/hue.ini file, modify hive_conf_dir to point to the directory containing hive-site.xml file.

  2. 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).


loading table of contents...