Zeppelin hive interpreter throws a ClassNotFoundException

Question

I deployed zeppelin 0.6 and set up a bush under the Jdbc interpreter.

Done

%hive     
show databases

Throws:

org.apache.hive.jdbc.HiveDriver class java.lang.ClassNotFoundException java.net.URLClassLoader.findClass (URLClassLoader.javahaps81) java.lang.ClassLoader.loadClass (ClassLoader.java:424) sun.misc.Launcher $ AppClassLouncher .loadClass (Launcher.javahaps31) java.lang.ClassLoader.loadClass (ClassLoader.javahaps57) java.lang.Class.forName0 (native method) java.lang.Class.forName (Class.java:264) org. apache.zeppelin.jdbc.JDBCInterpreter.getConnection (JDBCInterpreter.java:220) org.apache.zeppelin.jdbc.JDBCInterpreter.getStatement (JDBCInterpreter.java:233) org.apache.zeppelter.jreberjecreter.jpreter.jecreter.ecreter.ecreter.jecreter.ecreter.ecreter.ecreter 292) org.apache.zeppelin.jdbc.JDBCInterpreter.interpret (JDBCInterpreter.java{98) org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret (LazyOpenInterpreter.java:94) org.apachepreter.repreter.repreter.repreter.repreter.repreter.repreter.repelter.repreter.repreter.repelter.repreter.repreter.repreter.repelter.repreter.repreter.repreter.repelterRemoteInterpreterServer $ InterpretJob.jobRun (RemoteInterpreterServer.javahaps83) org.apache.zeppelin.scheduler.Job.run (Job.java:176) org.apache.zeppelin.scheduler.ParallelScheduler $ JobRunner.run2ava parallel java.util. : 180) java.util.concurrent.ScheduledThreadPoolExecutor $ ScheduledFutureTask.run (ScheduledThreadPoolExecutor.java:293) java.util.concurrent.ThreadPoolExecutor.runWorker (ThreadPoolExecutor.java:1142) java.utilecutor.curilutorcurcurcurrent .java: 617) java.lang.Thread.run (Thread.java:745)scheduler.Job.run (Job.java:176) org.apache.zeppelin.scheduler.ParallelScheduler $ JobRunner.run (ParallelScheduler.java:162) java.util.concurrent.Executors $ RunnableAdapter.call (Executors.java∗11) java.util. : 293) java.util.concurrent.ThreadPoolExecutor.runWorker (ThreadPoolExecutor.java:1142) java.util.concurrent.ThreadPoolExecutor $ Worker.run (ThreadPoolExecutor.java:617) java.lang.Thread.run (Thread.java:745 )scheduler.Job.run (Job.java:176) org.apache.zeppelin.scheduler.ParallelScheduler $ JobRunner.run (ParallelScheduler.java:162) java.util.concurrent.Executors $ RunnableAdapter.call (Executors.java∗11) java.util. : 293) java.util.concurrent.ThreadPoolExecutor.runWorker (ThreadPoolExecutor.java:1142) java.util.concurrent.ThreadPoolExecutor $ Worker.run (ThreadPoolExecutor.java:617) java.lang.Thread.run (Thread.java:745 )call (Executors.javaPoint11) java.util.concurrent.FutureTask.run (FutureTask.java:266) java.util.concurrent.ScheduledThreadPoolExecutor $ ScheduledFutureTask.access $ 201 (ScheduledThreadPoolExecutor.java:180) java.utecilecutecilecilecilecilecilecilecilecilecilecilecilecilecilecilecilecilecilecilecilecilecilecutecil $ ScheduledFutureTask.run (ScheduledThreadPoolExecutor.java:293) java.util.concurrent.ThreadPoolExecutor.runWorker (ThreadPoolExecutor.java:1142) java.util.concurrent.ThreadPoolExecutor $ Worker.run (ThreadPoolExecutor) .run (Thread.java:745)call (Executors.javaPoint11) java.util.concurrent.FutureTask.run (FutureTask.java:266) java.util.concurrent.ScheduledThreadPoolExecutor $ ScheduledFutureTask.access $ 201 (ScheduledThreadPoolExecutor.java:180) java.utecilecutecilecilecilecilecilecilecilecilecilecilecilecilecilecilecilecilecilecilecilecilecilecutecil $ ScheduledFutureTask.run (ScheduledThreadPoolExecutor.java:293) java.util.concurrent.ThreadPoolExecutor.runWorker (ThreadPoolExecutor.java:1142) java.util.concurrent.ThreadPoolExecutor $ Worker.run (ThreadPoolExecutor) .run (Thread.java:745)runWorker (ThreadPoolExecutor.java:1142) java.util.concurrent.ThreadPoolExecutor $ Worker.run (ThreadPoolExecutor.java:617) java.lang.Thread.run (Thread.java:745)runWorker (ThreadPoolExecutor.java:1142) java.util.concurrent.ThreadPoolExecutor $ Worker.run (ThreadPoolExecutor.java:617) java.lang.Thread.run (Thread.java:745)

Answer 1

. , , Hive 1.2 Hadoop 2.6.4. ./interpreter/jdbc/ zeppelin ./bin/zeppelin-daemon.sh reload

cp ~/Dev/Hadoop/apache-hive-1.2.1-bin/lib/hive-jdbc-1.2.1-standalone.jar ./interpreter/jdbc/

cp ~/Dev/Hadoop/hadoop-2.6.4/share/hadoop/common/hadoop-common-2.6.4.jar ./interpreter/jdbc/

Answer 2

1) Hive JDBC- Hive, , Cloudera:

http://www.cloudera.com/downloads/connectors/hive/jdbc/2-5-17.html

2)

, 0,14, JDBC:

-standalone.jar JDBC

, https://issues.apache.org/jira/browse/HIVE-9600 , :

Hadoop-common.jar

Hadoop-auth.jar

classpath hive-jdbc-standalone.jar

Answer 3

Highest rating here fixes the problem

However, I added the HADOOP_HOME class path to interpreter.sh to take jar files in general

Below is the line I added to bin / interpreter.sh inside zeppelin

HADOOP_HOME=/opt/hadoop-2.6.2/
addJarInDirForIntp "${HADOOP_HOME}/share/hadoop/common