Hive Insert Overwrite Query Fails with 'Error during instantiating JDBC driver org.apache.derby.jdbc.EmbeddedDriver'

(Doc ID 1981167.1)

Last updated on OCTOBER 11, 2016

Applies to:

Big Data Appliance Integrated Software - Version 3.0 to 4.0 [Release 3.0 to 4.0]
Linux x86-64


On Oracle Big Data Appliance (BDA) , Hive ' Insert .. Overwrite' query executed from either beeline , hive shell or Hue fails with below error:

ERROR [main] org.apache.hadoop.hive.ql.stats.jdbc.JDBCStatsPublisher: Error during instantiating JDBC driver org.apache.derby.jdbc.EmbeddedDriver.
 java.lang.ClassNotFoundException: org.apache.derby.jdbc.EmbeddedDriver
 at Method)
 at java.lang.ClassLoader.loadClass(
 at sun.misc.Launcher$AppClassLoader.loadClass(
 at java.lang.ClassLoader.loadClass(
 at java.lang.Class.forName0(Native Method)
 at java.lang.Class.forName(
 at org.apache.hadoop.hive.ql.stats.jdbc.JDBCStatsPublisher.connect(



Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms