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 <[email protected] > 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 <[email protected]> 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 >> >> >
