Hi, thanks for the replies, I get it now to work, the jar file was not correctly done. Now it works like a charm.
Regards, Jean-Charles Von: bejoy...@yahoo.com [mailto:bejoy...@yahoo.com] Gesendet: Montag, 6. Februar 2012 19:48 An: user@hive.apache.org Betreff: Re: Error when Creating an UDF Hi One of your jar is not available and may be that has the required UDF or any related methods. Hive was not able to locate your first jar '/scripts/hiveMd5.jar does not exist' Just fix this with the correct location. Everything should work fine. Regards Bejoy K S >From handheld, Please excuse typos. ________________________________ From: Jean-Charles Thomas <jctho...@autoscout24.com> Date: Mon, 6 Feb 2012 16:51:58 +0100 To: user@hive.apache.org<user@hive.apache.org> ReplyTo: user@hive.apache.org 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