AnsweredAssumed Answered

Hive: Class not found exception

Question asked by ghousia on Nov 28, 2011
Latest reply on Nov 29, 2011 by richa
We always get this exception for any hive query we run.
 
 org.apache.hadoop.hive.ql.stats.jdbc.JDBCStatsPublisher: Error during JDBC

> connection to jdbc:derby:;databaseName=TempStatsStore;create=true.
> java.lang.ClassNotFoundException: org.apache.derby.jdbc.EmbeddedDriver
>         at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
>         at java.security.AccessController.doPrivileged(Native Method)
>         at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
>         at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
>         at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
>         at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
>         at java.lang.Class.forName0(Native Method)
>         at java.lang.Class.forName(Class.java:169)
>         at
> org.apache.hadoop.hive.ql.stats.jdbc.JDBCStatsPublisher.connect(JDBCStatsPublisher.java:55)
>         at
> org.apache.hadoop.hive.ql.exec.FileSinkOperator.publishStats(FileSinkOperator.java:781)
>         at
> org.apache.hadoop.hive.ql.exec.FileSinkOperator.closeOp(FileSinkOperator.java:649)
>         at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:557)
>         at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:566)
>         at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:566)
>         at
> org.apache.hadoop.hive.ql.exec.ExecReducer.close(ExecReducer.java:303)
>         at
> org.apache.hadoop.mapred.ReduceTask.runOldReducer(ReduceTask.java:473)
>         at org.apache.hadoop.mapred.ReduceTask.run(ReduceTask.java:411)
>         at org.apache.hadoop.mapred.Child.main(Child.java:170)
>> org.apache.hadoop.hive.ql.exec.FileSinkOperator: StatsPublishing error:
> cannot connect to database
> The execution of query is successful, but still the log shows these errors.

Outcomes