Created on
06-28-2020
09:27 AM
- last edited on
06-29-2020
02:48 AM
by
VidyaSargur
Dear Gents,
I am using Cloudera QuickStart (CDH 5.13.0, Packages)
I have created JAVA UDF function named omlower as test case for HIVE UDF using JAVA.
but it is not working and return this error
"Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.FunctionTask"
I used these steps
1- Create omlower.java file with this content
package com.example.hive.udf;
import org.apache.hadoop.hive.ql.exec.UDF;
import org.apache.hadoop.io.Text;
public final class omlower extends UDF {
public Text evaluate(final Text s) {
if (s == null) { return null; }
return new Text(s.toString().toLowerCase());
}
}
2- compile is succesfully using [cloudera@quickstart ~]$ javac omlower.java -cp $(hadoop classpath)
3- create Jar file using [cloudera@quickstart ~]$ jar -cvf omlower.jar omlower.class -cp $(hadoop classpath)
4- copy JAR file to HDFS directory /user
5- using HUE UI and HIVE editor , I tried to create UDF Function
CREATE FUNCTION omlower AS 'com.example.hive.udf.omlower' USING JAR 'hdfs:/user/omlower.jar';
but it gives this error "Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.FunctionTask"
any help please
Regards
Omran