My Oracle Support Banner

Hive Insert Overwrite Query Fails with 'Error during instantiating JDBC driver org.apache.derby.jdbc.EmbeddedDriver' (Doc ID 1981167.1)

Last updated on NOVEMBER 22, 2019

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(



To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.