Support Questions
Find answers, ask questions, and share your expertise

Load permanent udf in HiveServer2 and HiveServer Interactive


Load permanent udf in HiveServer2 and HiveServer Interactive

New Contributor

Someone have a documentation to deploy permanent udfs on HS2 and HSI on HDP 3.1.0.

In HDP 3.0.1

We added "hive.reloadable.aux.jars.path" and "hive.aux.jars.path" to "hive-site" and everything was working well

On HDP 3.1.0

HS2 is working without any issue but not HSI
When LLAP start we this "warn" message...

2019-01-21T16:22:01,786 WARN [llap-pkg-1] cli.LlapServiceDriver: Missing resources for <database>.<udf-name>
Any query are now failing with

Error while processing statement: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.tez.TezTask. Vertex failed, vertexName=Map 1, vertexId=vertex_1547822771907_0049_2_00, diagnostics=[Task failed, taskId=task_1547822771907_0049_2_00_000000, diagnostics=[TaskAttempt 0 failed, info=[Error: Error while running task ( failure ) : java.lang.reflect.InvocationTargetException at

Query exemple:
INSERT INTO TABLE purger_tablestopurge_2 VALUES ('aaa','aaaa',28,'Purge to remove old data that is contained anyway');

When we remove the jar all the queries are workings without any issue