Tips for setting up Apache Hive

In order for Apache Hive to work with PI Integrator for Business Analytics, you must complete the following tasks:

• Create the HDFS user.

• Create the HCat user.

• Create the user directory and grant permissions.

• Disable SASL.

The following procedure describes how to complete these tasks.

1. Create the HDFS user.

   1. Create the HDFS user on the node where WebHDFS is installed.

   2. Add the HDFS user to a group.

   Note: The HDFS user can be added to any group. However, for the purposes of this example, this group will be referred to as the HDFS group.

2. Create the HCat user.

   (Optional) If HCat is on a different node, then you must add the HCat user.

   1. Create the HCat user on the node where HCat is installed.

   2. Add the HCat user to the HDFS group.

3. Create the user directory and grant permissions.

   In the following procedure, you create a user directory and ensure it is set up correctly so that the HDFS user can write to it.

   1. Create a user directory on HDFS.

   2. Change the owner of this directory to the HDFS user.

   3. Change the group to which this directory belongs to HDFS.

   4. Grant read and write permissions to the owner of the directory (that is, the HDFS user).

   5. Grant read and write permissions to the group to which the directory belongs.

4. Disable SASL.

   Note: PI Integrator for Business Analytics only supports Apache Hive targets that are configured with NOSASL authentication. For more information on Apache Hive authentication options, see Setting Up HiveServer2.