Skip to main content
ddharam
Gold ⭐️
ddharam
Gold ⭐️
January 1, 2017

jdbc hive interpreter fails while running hive queries

  • October 5, 2026 at 9:30 AM
  • 0 replies
  • 2209 views
  • Translate All

Error:

%jdbc (Hive)

java.util.ServiceConfigurationError: javax.xml.parsers.DocumentBuilderFactory: Provider org.apache.xerces.jaxp.DocumentBuilderFactoryImpl not found
at java.util.ServiceLoader.fail(ServiceLoader.java:239)
at java.util.ServiceLoader.access$300(ServiceLoader.java:185)
at java.util.ServiceLoader$LazyIterator.nextService(ServiceLoader.java:372)
at java.util.ServiceLoader$LazyIterator.next(ServiceLoader.java:404) at java.util.ServiceLoader$1.next(ServiceLoader.java:480)
at javax.xml.parsers.FactoryFinder$1.run(FactoryFinder.java:294)
at java.security.AccessController.doPrivileged(Native Method)
at javax.xml.parsers.FactoryFinder.findServiceProvider(FactoryFinder.java:289)
at javax.xml.parsers.FactoryFinder.find(FactoryFinder.java:267)
at javax.xml.parsers.DocumentBuilderFactory.newInstance(DocumentBuilderFactory.java:120)
at org.apache.hadoop.conf.Configuration.loadResource(Configuration.java:2549)
at org.apache.hadoop.conf.Configuration.loadResources(Configuration.java:2526)
at org.apache.hadoop.conf.Configuration.getProps(Configuration.java:2418)
at org.apache.hadoop.conf.Configuration.set(Configuration.java:1143)
at org.apache.hadoop.conf.Configuration.set(Configuration.java:1115)

SOLUTION:

Copy the following jars : xercesImpl*.jar and xml-apis*

For eg:

Can be found by running

locate xercesImpl* on any of the node in he cluster

copy

/usr/hdp/<hadoop-version>/hadoop/client/xercesImpl-2.9.1.jar

to: /usr/hdp/current/zeppelin-server/interpreter/jdbc/

Restart the interpreter

    Terms & ConditionsAccessibility statement