jdbc hive interpreter fails while running hive queries

[#1]

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