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.