If you cannot public maven repos, you'd better copy that jar into your interpreter/hive/. It would work. I'll also find a better way.
Hope this help, J On Fri, Apr 29, 2016 at 2:56 PM, ÐΞ€ρ@Ҝ (๏̯͡๏) <[email protected]> wrote: > 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, ÐΞ€ρ@Ҝ (๏̯͡๏) <[email protected]> > wrote: > >> My setup is behind firewall , how will Zeppelin pull the dependency ? >> >> On Thu, Apr 28, 2016 at 6:02 PM Jongyoul Lee <[email protected]> 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, ÐΞ€ρ@Ҝ (๏̯͡๏) <[email protected]> >>> 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 > > -- 이종열, Jongyoul Lee, 李宗烈 http://madeng.net
