Hello,
· With UDF you do this :
package com.example.hive.udf;
import org.apache.hadoop.hive.ql.exec.UDF;
public final class Maclass extends UDF{.....}
· then you generate your jar monjar.jar (for example) with java class
(maclass)
· you add you jar to hive:
hive> add jar Maclass.jar
· you create then an UDF like:
hive> create temporary function mafonction as 'com.example.hive.udf.monjar';
· and then use mafonction in hive query.
Hope that this help you
Best regard
Matouk.
De : Tamil A [mailto:[email protected]]
Envoyé : jeudi 6 septembre 2012 14:26
À : [email protected]
Objet : UDAF:FAILED: Execution Error
Hi Experts,
I have written an UDAF function and followed the below steps.
Step 1:
Export jar file
Step 2:
hive>ADD JAR /userdata/tamil/SumOfColumnTest/AvgOfColumn.jar;
(also tried with hive --auxpath /userdata/tamil/SumOfColumnTest/AvgOfColumn.jar;
export
HADOOP_CLASSPATH=$HADOOP_CLASSPATH:/userdata/tamil/SumOfColumnTest/AvgOfColumn.jar)
hive>list jar;
/userdata/tamil/SumOfColumnTest/AvgOfColumn.jar
Step 3;
hive>CREATE TEMPORARY FUNCTION avge AS 'com.hadoopbook.hive.UDAFExampleAvg';
but after this got the below error,
FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.FunctionTask
is the above procedure i followed is same for UDF and UDAF or some other
changes are to be made for UDAF.
Please help me out,
Thanks & Regards,
Tamil