RE: ClassNotFoundException every time we run any hive query

[Chinna Rao Lalam]

Hi,



This class "org.apache.derby.jdbc.EmbeddedDriver" will present  in the  
derby.jar normally the hive distribution will come with this jar

for example HIVE0.8 will contain derby-10.4.2.0.jar.



Check derby.jar present in {HIVE_HOME}/lib or not



And version details can u add to the mail..



Hope it helps,

Chinna Rao Lalam



________________________________
From: Ghousia [ghousia.ath...@gmail.com]
Sent: Monday, November 28, 2011 1:14 PM
To: user@hive.apache.org
Subject: ClassNotFoundException every time we run any hive query

Hi,

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


Many Thanks,
Ghousia.