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