You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Jean-Charles Thomas <JC...@autoscout24.com> on 2012/02/06 16:51:58 UTC
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
Re: Error when Creating an UDF
Posted by alo alt <wg...@googlemail.com>.
Btw, welcome on the list, JC!
:)
--
Alexander Lorenz
http://mapredit.blogspot.com
On Feb 7, 2012, at 10:57 AM, Jean-Charles Thomas wrote:
> 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_ks@yahoo.com [mailto:bejoy_ks@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 <JC...@autoscout24.com>
> Date: Mon, 6 Feb 2012 16:51:58 +0100
> To: user@hive.apache.org<us...@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
>
AW: Error when Creating an UDF
Posted by Jean-Charles Thomas <JC...@autoscout24.com>.
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_ks@yahoo.com [mailto:bejoy_ks@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 <JC...@autoscout24.com>
Date: Mon, 6 Feb 2012 16:51:58 +0100
To: user@hive.apache.org<us...@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
Re: Error when Creating an UDF
Posted by be...@yahoo.com.
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.
-----Original Message-----
From: Jean-Charles Thomas <JC...@autoscout24.com>
Date: Mon, 6 Feb 2012 16:51:58
To: user@hive.apache.org<us...@hive.apache.org>
Reply-To: 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
Re: Error when Creating an UDF
Posted by Aniket Mokashi <an...@gmail.com>.
Add your udf jar to HADOOP_CLASSPATH
Thanks,
Aniket
On Mon, Feb 6, 2012 at 10:01 AM, Mark Grover <mg...@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: mgrover@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" <JC...@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"
Re: Error when Creating an UDF
Posted by Mark Grover <mg...@oanda.com>.
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: mgrover@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" <JC...@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