7.1 Loading UDF file in HIVE

To load the UDF file in HIVE, follow these steps:

1. Copy the JAR file $FIC_HOME/realtime_processing/ipeudf /lib/ofsaa_ipe_udf.jar to the host on which HIVEServer2 is running.
2. Provide the HIVE user with Read, Write and Execute permissions to this directory, and make a note of the path (For example, /opt/local/hive/lib/).
3. Login to the Cloudera Manager Console as an admin user and navigate to Clusters menu, click on HIVE. The HIVE service window appears.
4. Click the Configuration tab.

   Note:

   This is the Classic layout of the Cloudera Manager console.
5. Click Service-Wide menu and select Advanced.
6. Configure the HIVE Auxiliary JARs Directory property with the HIVEServer2 host path from Step 1, /opt/local/hive/lib/.
7. Click Save Changes. The JARs are added to HIVE_AUX_JARS_PATH environment variable.
8. Redeploy the HIVE client configuration. Follow these steps:
   1. Navigate to the HIVE service in the Cloudera Manager Admin Console.
   2. On the Actions menu, select Deploy Client Configuration.
   3. Click Deploy Client Configuration.
9. Restart the HIVE service. If the HIVE Auxiliary JARs Directory property is configured but the directory does not exist, HIVEServer2 does not start. Follow these steps:
   1. On the Actions menu, select Restart.
   2. Click Restart.