Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Load permanent udf in HiveServer2 and HiveServer Interactive

Load permanent udf in HiveServer2 and HiveServer Interactive

New Contributor

Hi,
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.io.IOException: java.lang.reflect.InvocationTargetException at org.apache.hadoop.hive.io.HiveIOExceptionHandlerChain.handleRecordReaderCreationException(HiveIOExceptionHandlerChain.java:97)

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

Don't have an account?
Coming from Hortonworks? Activate your account here