Hi Jean-Charles, Please make sure that your jar is built properly and the class com.autoscout24.hive.udf.Md5 exists within the jar. Also, make sure the jar gets added properly to Hive. You can verify that by typing "list jars;" on hive command line. You should see your jar name.
Mark Mark Grover, Business Intelligence Analyst OANDA Corporation www: oanda.com www: fxtrade.com e: mgro...@oanda.com "Best Trading Platform" - World Finance's Forex Awards 2009. "The One to Watch" - Treasury Today's Adam Smith Awards 2009. ----- Original Message ----- From: "Jean-Charles Thomas" <jctho...@autoscout24.com> To: user@hive.apache.org Sent: Monday, February 6, 2012 10:51:58 AM Subject: Error when Creating an UDF Hi everybody, i am trying to create an UDF follwing the example in the Hive Wiki. Everything is fine but the CREATE statement (see below) where an error occurs: hive> add jar /scripts/hiveMd5.jar; /scripts/hiveMd5.jar does not exist hive> add jar /scripts/hive/udf/Md5.jar; Added /scripts/hive/udf/Md5.jar to class path Added resource: /scripts/hive/udf/Md5.jar hive> CREATE TEMPORARY FUNCTION mymd5 AS 'com.autoscout24.hive.udf.Md5'; FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.FunctionTask hive> in the Hive log, there is no much more: 2012-02-06 16:16:36,096 ERROR ql.Driver (SessionState.java:printError(343)) - FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.FunctionTask Any Help is welcome, Thanks a lot for hlep, Jean-Charles