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.