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

  3. Ensure that the hive.security.authorization.manager class is visible to Hue.

    For example, if


    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/.

loading table of contents...