Zeppelin ClassNotFoundException

[#1]

Hi Folks,

I'm going through the tutorial for hdp 2.5.0

In the following lab I'm encountering issues with http://hortonworks.com/hadoop-tutorial/hello-world-an-introduction-to-hadoop-hcatalog-hive-and-pig/#...

I'm getting class not found exception (see code below) which I have no clue how to solve! (default setting in the interpreter menu throws a file not found notification when I try to save the default settings) see attached picture.

Any help would be appreciated thanks 🙂

%hive
show tables
org.apache.hive.jdbc.HiveDriver
class java.lang.ClassNotFoundException
java.net.URLClassLoader$1.run(URLClassLoader.java:366)
java.net.URLClassLoader$1.run(URLClassLoader.java:355)
java.security.AccessController.doPrivileged(Native Method)
java.net.URLClassLoader.findClass(URLClassLoader.java:354)
java.lang.ClassLoader.loadClass(ClassLoader.java:425)
sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
java.lang.ClassLoader.loadClass(ClassLoader.java:358)
java.lang.Class.forName0(Native Method)
java.lang.Class.forName(Class.java:195)
org.apache.zeppelin.jdbc.JDBCInterpreter.getConnection(JDBCInterpreter.java:214)
org.apache.zeppelin.jdbc.JDBCInterpreter.getStatement(JDBCInterpreter.java:275)
org.apache.zeppelin.jdbc.JDBCInterpreter.executeSql(JDBCInterpreter.java:336)
org.apache.zeppelin.jdbc.JDBCInterpreter.interpret(JDBCInterpreter.java:442)
org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:94)
org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:341)
org.apache.zeppelin.scheduler.Job.run(Job.java:176)
org.apache.zeppelin.scheduler.ParallelScheduler$JobRunner.run(ParallelScheduler.java:162)
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
java.util.concurrent.FutureTask.run(FutureTask.java:262)
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178)
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
java.lang.Thread.run(Thread.java:745)

I can't get the interpreter to run in lab 5 either

%jbdc (hive)
SELECT * FROM riskfactor

prefix not found

[#2 · Accepted solution]

Answering my own question!

In the following post I found my answer https://community.hortonworks.com/questions/56113/trying-to-create-phoenix-interpreter-using-jdbc-in...

I created a new "test jdbc interpreter" left every setting default but added the following dependancies below. My newly created interpreter works but the default %jdbc interpreter still faults with the path error as in the attached picture.

org.apache.hive:hive-jdbc:0.14.0 org.apache.hadoop:hadoop-common:2.6.0

Many thanks!

@Randy Gelhausen