Add your udf jar to HADOOP_CLASSPATH Thanks, Aniket
On Mon, Feb 6, 2012 at 10:01 AM, Mark Grover <mgro...@oanda.com> wrote: > 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 > > > > -- "...:::Aniket:::... Quetzalco@tl"