Hi,
I can use JDBC connection to connect from Squirrel client to Spark thrift
server and this works fine.
I have Zeppelin 0.6.o that works OK with the default spark interpreter.
I configured JDBC interpreter to connect to Spark thrift server as follows
[image: Inline images 1]
I can use beeline to connect to STS no problem
beeline -u jdbc:hive2://rhes564:10055 -n hduser -p
Connecting to jdbc:hive2://rhes564:10055
Connected to: Spark SQL (version 1.6.1)
Driver: Hive JDBC (version 2.0.0)
16/07/11 05:39:19 [main]: WARN jdbc.HiveConnection: Request to set
autoCommit to false; Hive does not support autoCommit=false.
Transaction isolation: TRANSACTION_REPEATABLE_READ
Beeline version 2.0.0 by Apache Hive
Now the problem I have when I use Zeppelin to connect to STS with "show
databases", I I get the following error in jdbc log
INFO [2016-07-11 05:43:27,132] ({pool-2-thread-4}
SchedulerFactory.java[jobFinished]:137) - Job
remoteInterpretJob_1468212207128 finished by scheduler
org.apache.zeppelin.jdbc.JDBCInterpreter121016079
INFO [2016-07-11 05:43:54,413] ({pool-2-thread-6}
SchedulerFactory.java[jobStarted]:131) - Job
remoteInterpretJob_1468212234413 started by scheduler
org.apache.zeppelin.jdbc.JDBCInterpreter121016079
INFO [2016-07-11 05:43:54,413] ({pool-2-thread-6}
JDBCInterpreter.java[interpret]:385) - Run SQL command 'show databases'
INFO [2016-07-11 05:43:54,414] ({pool-2-thread-6}
JDBCInterpreter.java[interpret]:394) - PropertyKey: default, SQL command:
'show databases'
INFO [2016-07-11 05:43:54,418] ({pool-2-thread-6}
JDBCInterpreter.java[getConnection]:219) -
ERROR [2016-07-11 05:43:54,418] ({pool-2-thread-6}
JDBCInterpreter.java[executeSql]:366) - Cannot run show databases
java.lang.ClassNotFoundException:
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:264)
at
org.apache.zeppelin.jdbc.JDBCInterpreter.getConnection(JDBCInterpreter.java:220)
at
org.apache.zeppelin.jdbc.JDBCInterpreter.getStatement(JDBCInterpreter.java:233)
at
org.apache.zeppelin.jdbc.JDBCInterpreter.executeSql(JDBCInterpreter.java:292)
at
org.apache.zeppelin.jdbc.JDBCInterpreter.interpret(JDBCInterpreter.java:396)
at
org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:94)
at
org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:341)
at org.apache.zeppelin.scheduler.Job.run(Job.java:176)
at
org.apache.zeppelin.scheduler.ParallelScheduler$JobRunner.run(ParallelScheduler.java:162)
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
BTW I made both the following jars available under
$ZEPPELIN_HOME/interpreter/jdbc
lrwxrwxrwx 1 hduser hadoop 37 Jul 10 14:35 hive-jdbc-2.0.0.jar ->
/usr/lib/hive/lib/hive-jdbc-2.0.0.jar
lrwxrwxrwx 1 hduser hadoop 36 Jul 10 19:56 hive-cli-2.0.0.jar ->
/usr/lib/hive/lib/hive-cli-2.0.0.jar
Appreciate any feedback
Dr Mich Talebzadeh
LinkedIn *
https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
<https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
http://talebzadehmich.wordpress.com
*Disclaimer:* Use it at your own risk. Any and all responsibility for any
loss, damage or destruction of data or any other property which may arise
from relying on this email's technical content is explicitly disclaimed.
The author will in no case be liable for any monetary damages arising from
such loss, damage or destruction.
