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 >
