Member since
10-03-2016
2
Posts
3
Kudos Received
1
Solution
My Accepted Solutions
| Title | Views | Posted |
|---|---|---|
| 3899 | 10-03-2016 11:51 AM |
10-03-2016
11:51 AM
2 Kudos
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.html
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
... View more
10-03-2016
10:04 AM
1 Kudo
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/#step4.2
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
... View more
Labels: