You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Ryan LeCompte <le...@gmail.com> on 2010/06/02 20:37:13 UTC
Error while using Hive JDBC to execute a create temporary UDF
Hey guys,
We have a very simple JDBC client that uses the Hive JDBC driver to execute
queries. We are trying to use it to execute a simple "create temporary
function ..." statement, but Hive is throwing the following error:
Exception in thread "main" java.sql.SQLException: Query returned non-zero
code: 9, cause: FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.FunctionTask
at
org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:173)
at org.apache.hadoop.hive.jdbc.HiveStatement.execute(HiveStatement.java:115)
at HiveJdbcClient.main(HiveJdbcClient.java:31)
A simple "ADD FILE ..." works just fine, as well as other queries. This is
using Hive 0.5.
Thanks,
Ryan
Re: Error while using Hive JDBC to execute a create temporary UDF
Posted by Ryan LeCompte <le...@gmail.com>.
Just closing the loop here. Turns out it was a bug on our side... We had
single quotes in the initial ADD JAR command, which was causing the
subsequent create temporary function call to fail. Removed the quotes and
now we're all set.
Thanks,
Ryan
On Wed, Jun 2, 2010 at 4:44 PM, Ryan LeCompte <le...@gmail.com> wrote:
> Hi Vinithra,
>
> Yes, we registered the UDF with the ADD JAR command... and also the
> commands work fine in the CLI, it's only through the JDBC interface that it
> doesn't work.
>
> Could someone try executing one of these commands via JDBC to see if it's a
> legitimate bug in 0.5?
>
> Thanks!
>
> Ryan
>
>
>
> On Wed, Jun 2, 2010 at 3:34 PM, Vinithra Varadharajan <
> vinithra@cloudera.com> wrote:
>
>> Hi Ryan,
>>
>> Did you register the UDF with ADD JAR <udf.jar>? Note that you currently
>> cannot register a jar that is on HDFS (HIVE-1157).
>>
>> In case you've already done the above, have you tried the query from the
>> Hive CLI - do you get the same error?
>>
>> Also, could you attach the detailed logs from /tmp/<username>/hive?
>>
>> -Vinithra
>>
>>
>> On Wed, Jun 2, 2010 at 11:37 AM, Ryan LeCompte <le...@gmail.com>wrote:
>>
>>> Hey guys,
>>>
>>> We have a very simple JDBC client that uses the Hive JDBC driver to
>>> execute queries. We are trying to use it to execute a simple "create
>>> temporary function ..." statement, but Hive is throwing the following error:
>>>
>>> Exception in thread "main" java.sql.SQLException: Query returned non-zero
>>> code: 9, cause: FAILED: Execution Error, return code 1 from
>>> org.apache.hadoop.hive.ql.exec.FunctionTask
>>> at
>>> org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:173)
>>> at
>>> org.apache.hadoop.hive.jdbc.HiveStatement.execute(HiveStatement.java:115)
>>> at HiveJdbcClient.main(HiveJdbcClient.java:31)
>>>
>>> A simple "ADD FILE ..." works just fine, as well as other queries. This
>>> is using Hive 0.5.
>>>
>>> Thanks,
>>> Ryan
>>>
>>>
>>
>
Re: Error while using Hive JDBC to execute a create temporary UDF
Posted by Ryan LeCompte <le...@gmail.com>.
Hi Vinithra,
Yes, we registered the UDF with the ADD JAR command... and also the commands
work fine in the CLI, it's only through the JDBC interface that it doesn't
work.
Could someone try executing one of these commands via JDBC to see if it's a
legitimate bug in 0.5?
Thanks!
Ryan
On Wed, Jun 2, 2010 at 3:34 PM, Vinithra Varadharajan <vinithra@cloudera.com
> wrote:
> Hi Ryan,
>
> Did you register the UDF with ADD JAR <udf.jar>? Note that you currently
> cannot register a jar that is on HDFS (HIVE-1157).
>
> In case you've already done the above, have you tried the query from the
> Hive CLI - do you get the same error?
>
> Also, could you attach the detailed logs from /tmp/<username>/hive?
>
> -Vinithra
>
>
> On Wed, Jun 2, 2010 at 11:37 AM, Ryan LeCompte <le...@gmail.com> wrote:
>
>> Hey guys,
>>
>> We have a very simple JDBC client that uses the Hive JDBC driver to
>> execute queries. We are trying to use it to execute a simple "create
>> temporary function ..." statement, but Hive is throwing the following error:
>>
>> Exception in thread "main" java.sql.SQLException: Query returned non-zero
>> code: 9, cause: FAILED: Execution Error, return code 1 from
>> org.apache.hadoop.hive.ql.exec.FunctionTask
>> at
>> org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:173)
>> at
>> org.apache.hadoop.hive.jdbc.HiveStatement.execute(HiveStatement.java:115)
>> at HiveJdbcClient.main(HiveJdbcClient.java:31)
>>
>> A simple "ADD FILE ..." works just fine, as well as other queries. This is
>> using Hive 0.5.
>>
>> Thanks,
>> Ryan
>>
>>
>
Re: Error while using Hive JDBC to execute a create temporary UDF
Posted by Vinithra Varadharajan <vi...@cloudera.com>.
Hi Ryan,
Did you register the UDF with ADD JAR <udf.jar>? Note that you currently
cannot register a jar that is on HDFS (HIVE-1157).
In case you've already done the above, have you tried the query from the
Hive CLI - do you get the same error?
Also, could you attach the detailed logs from /tmp/<username>/hive?
-Vinithra
On Wed, Jun 2, 2010 at 11:37 AM, Ryan LeCompte <le...@gmail.com> wrote:
> Hey guys,
>
> We have a very simple JDBC client that uses the Hive JDBC driver to execute
> queries. We are trying to use it to execute a simple "create temporary
> function ..." statement, but Hive is throwing the following error:
>
> Exception in thread "main" java.sql.SQLException: Query returned non-zero
> code: 9, cause: FAILED: Execution Error, return code 1 from
> org.apache.hadoop.hive.ql.exec.FunctionTask
> at
> org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:173)
> at
> org.apache.hadoop.hive.jdbc.HiveStatement.execute(HiveStatement.java:115)
> at HiveJdbcClient.main(HiveJdbcClient.java:31)
>
> A simple "ADD FILE ..." works just fine, as well as other queries. This is
> using Hive 0.5.
>
> Thanks,
> Ryan
>
>