User-Defined Functions (UDFs) with HiveServer2 Using Cloudera Manager

Creating Permanent Functions

1. Copy the JAR file to HDFS and make sure the hive user can access this JAR file.
2. Copy the JAR file to the host on which HiveServer2 is running. Save the JARs to any directory you choose, give the hive user read, write, and execute access to this directory, and make a note of the path (for example,/opt/local/hive/lib/).
3. In the Cloudera Manager Admin Console, go to the Hive service.
4. Click the Configuration tab.
5. Expand the Service-Wide > Advanced categories.
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.
   1. In the Cloudera Manager Admin Console, go to the Hive service.
   2. From the Actions menu at the top right of the service page, 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 will not start.
10. If Sentry is enabled - Grant privileges on the JAR files to the roles that require access. Login to Beeline as user hive and use the Hive SQL GRANT statement to do so. For example:

    GRANT ALL ON URI 'file:///opt/local/hive/lib/my.jar' TO ROLE EXAMPLE_ROLE

    You must also grant privilege to the JAR on HDFS:

    GRANT ALL ON URI 'hdfs:///path/to/jar' TO ROLE EXAMPLE_ROLE

11. Run the CREATE FUNCTION command and point to the JAR file location in HDFS. For example:

    CREATE FUNCTION addfunc AS 'com.example.hiveserver2.udf.add' USING JAR 'hdfs:///path/to/jar'

12.