You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@zeppelin.apache.org by ๏̯͡๏ <ÐΞ€ρ@Ҝ>,
de...@gmail.com on 2016/04/29 01:49:22 UTC
Unable to use Hive Interpreter
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
Re: Unable to use Hive Interpreter
Posted by Jongyoul Lee <jo...@gmail.com>.
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, ÐΞ€ρ@Ҝ (๏̯͡๏) <de...@gmail.com> 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, ÐΞ€ρ@Ҝ (๏̯͡๏) <de...@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 <jo...@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, ÐΞ€ρ@Ҝ (๏̯͡๏) <de...@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
>
>
--
이종열, Jongyoul Lee, 李宗烈
http://madeng.net
Re: Unable to use Hive Interpreter
Posted by ๏̯͡๏ <ÐΞ€ρ@Ҝ>,
de...@gmail.com.
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, ÐΞ€ρ@Ҝ (๏̯͡๏) <de...@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 <jo...@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, ÐΞ€ρ@Ҝ (๏̯͡๏) <de...@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
Re: Unable to use Hive Interpreter
Posted by ๏̯͡๏ <ÐΞ€ρ@Ҝ>,
de...@gmail.com.
My setup is behind firewall , how will Zeppelin pull the dependency ?
On Thu, Apr 28, 2016 at 6:02 PM Jongyoul Lee <jo...@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, ÐΞ€ρ@Ҝ (๏̯͡๏) <de...@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
>
Re: Unable to use Hive Interpreter
Posted by Jongyoul Lee <jo...@gmail.com>.
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, ÐΞ€ρ@Ҝ (๏̯͡๏) <de...@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