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 > >
