I copied mysql-connector into lib directory. Same error
({pool-2-thread-2} HiveInterpreter.java[executeSql]:294) - Cannot run show tables; java.lang.ClassNotFoundException: com.mysql.jdbc.Driver at java.net.URLClassLoader$1.run(URLClassLoader.java:366) at java.net.URLClassLoader$1.run(URLClassLoader.java:355) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:354) at java.lang.ClassLoader.loadClass(ClassLoader.java:425) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308) at java.lang.ClassLoader.loadClass(ClassLoader.java:358) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:191) at org.apache.zeppelin.hive.HiveInterpreter.getConnection(HiveInterpreter.java:184) at org.apache.zeppelin.hive.HiveInterpreter.getStatement(HiveInterpreter.java:204) at org.apache.zeppelin.hive.HiveInterpreter.executeSql(HiveInterpreter.java:233) at org.apache.zeppelin.hive.HiveInterpreter.interpret(HiveInterpreter.java:328) at org.apache.zeppelin.interpreter.ClassloaderInterpreter.interpret(ClassloaderInterpreter.java:57) at org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:93) at org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:300) at org.apache.zeppelin.scheduler.Job.run(Job.java:169) at org.apache.zeppelin.scheduler.ParallelScheduler$JobRunner.run(ParallelScheduler.java:157) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) INFO [2016-04-28 22:55:42,100] ({pool-2-thread-2} SchedulerFactory.java[jobFinished]:135) - Job remoteInterpretJob_1461909342074 finished by scheduler org.apache.zeppelin.hive.HiveInterpreter806728451 On Thu, Apr 28, 2016 at 10:31 PM, ÐΞ€ρ@Ҝ (๏̯͡๏) <deepuj...@gmail.com> wrote: > My setup is behind firewall , how will Zeppelin pull the dependency ? > > On Thu, Apr 28, 2016 at 6:02 PM Jongyoul Lee <jongy...@gmail.com> wrote: > >> Hi, >> >> You should use set the mysql dependency like >> 'mysql:mysql-connector-java:5.1.38'. Please check >> http://zeppelin.incubator.apache.org/docs/0.6.0-incubating-SNAPSHOT/interpreter/jdbc.html >> >> >> Hope this help, >> Jongyoul >> >> On Fri, Apr 29, 2016 at 8:49 AM, ÐΞ€ρ@Ҝ (๏̯͡๏) <deepuj...@gmail.com> >> wrote: >> >>> I am able to run hive command from command prompt and able to connect to >>> my production cluster. Now i want to try Hive interpreter >>> >>> >>> Settings: >>> >>> I mapped the values to below settings from hive-site.xml >>> >>> common.max_count 1000 >>> default.driver com.mysql.jdbc.Driver >>> default.password >>> *default.url jdbc:mysql://host.vip.com:3306/HDB >>> <http://host.vip.com:3306/HDB>* >>> default.user hive >>> >>> Fields referred were: >>> <name>javax.jdo.option.ConnectionURL</name> >>> <name>javax.jdo.option.ConnectionDriverName</name> >>> <name>javax.jdo.option.ConnectionUserName</name> >>> <name>javax.jdo.option.ConnectionPassword</name> >>> >>> >>> Question >>> 1. How do i get it working ? >>> 2. Why should i provide these settings manually ? IF i can simply >>> specify the location of hive-site.xml. >>> >>> Appreciate your time. >>> >>> >>> Logs >>> ==== >>> >>> ERROR [2016-04-28 16:37:07,492] ({pool-2-thread-3} >>> HiveInterpreter.java[executeSql]:294) - Cannot run show tables; >>> >>> java.lang.ClassNotFoundException: com.mysql.jdbc.Driver >>> >>> at java.net.URLClassLoader$1.run(URLClassLoader.java:366) >>> >>> at java.net.URLClassLoader$1.run(URLClassLoader.java:355) >>> >>> at java.security.AccessController.doPrivileged(Native Method) >>> >>> at java.net.URLClassLoader.findClass(URLClassLoader.java:354) >>> >>> at java.lang.ClassLoader.loadClass(ClassLoader.java:425) >>> >>> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308) >>> >>> at java.lang.ClassLoader.loadClass(ClassLoader.java:358) >>> >>> at java.lang.Class.forName0(Native Method) >>> >>> at java.lang.Class.forName(Class.java:191) >>> >>> at >>> org.apache.zeppelin.hive.HiveInterpreter.getConnection(HiveInterpreter.java:184) >>> >>> at >>> org.apache.zeppelin.hive.HiveInterpreter.getStatement(HiveInterpreter.java:204) >>> >>> at >>> org.apache.zeppelin.hive.HiveInterpreter.executeSql(HiveInterpreter.java:233) >>> >>> at >>> org.apache.zeppelin.hive.HiveInterpreter.interpret(HiveInterpreter.java:328) >>> >>> at >>> org.apache.zeppelin.interpreter.ClassloaderInterpreter.interpret(ClassloaderInterpreter.java:57) >>> >>> at >>> org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:93) >>> >>> at >>> org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:300) >>> >>> at org.apache.zeppelin.scheduler.Job.run(Job.java:169) >>> >>> at >>> org.apache.zeppelin.scheduler.ParallelScheduler$JobRunner.run(ParallelScheduler.java:157) >>> >>> at >>> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) >>> >>> at java.util.concurrent.FutureTask.run(FutureTask.java:262) >>> >>> at >>> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178) >>> >>> at >>> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292) >>> >>> at >>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) >>> >>> at >>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) >>> >>> at java.lang.Thread.run(Thread.java:745) >>> >>> INFO [2016-04-28 16:37:07,500] ({pool-2-thread-3} >>> SchedulerFactory.java[jobFinished]:135) - Job >>> remoteInterpretJob_1461886627489 finished by scheduler >>> org.apache.zeppelin.hive.HiveInterpreter533686947 >>> >>> -- >>> Deepak >>> >>> >> >> >> -- >> 이종열, Jongyoul Lee, 李宗烈 >> http://madeng.net >> > -- Deepak