You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@zeppelin.apache.org by Ram Shankar Yadav <ra...@gmail.com> on 2016/08/10 11:25:19 UTC
Problem while creating mysql interpreter
Hi,
I was trying to create mysql interpreter using the reference document :
https://zeppelin.apache.org/docs/0.6.0/interpreter/jdbc.html
I added required details for creating the interpreter:
I've also added the Credentials inside Credentials tab
But I'm getting this output:
text:
> java.lang.ClassNotFoundException:
> org.apache.hadoop.security.UserGroupInformation$AuthenticationMethod
> at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
> at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:331)
> at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
> at
> org.apache.zeppelin.jdbc.security.JDBCSecurityImpl.getAuthtype(JDBCSecurityImpl.java:71)
> at
> org.apache.zeppelin.jdbc.JDBCInterpreter.getConnection(JDBCInterpreter.java:217)
> at
> org.apache.zeppelin.jdbc.JDBCInterpreter.getStatement(JDBCInterpreter.java:275)
> at
> org.apache.zeppelin.jdbc.JDBCInterpreter.executeSql(JDBCInterpreter.java:346)
> at
> org.apache.zeppelin.jdbc.JDBCInterpreter.interpret(JDBCInterpreter.java:452)
> at
> org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:94)
> at
> org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:383)
> at org.apache.zeppelin.scheduler.Job.run(Job.java:176)
> at
> org.apache.zeppelin.scheduler.FIFOScheduler$1.run(FIFOScheduler.java:139)
> 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)
Also,
I realized that Zeppelin automatically creates localrepo folder and mysql
driver inside : local-repo/mysql/mysql-connector-java
How can I use a custom JDBC driver? Where should I put my jdbc connector
jar files?
Cheers,
Ram
Re: Problem while creating mysql interpreter
Posted by Ram Shankar Yadav <ra...@gmail.com>.
Thanks Moon, appreciate your support!
I'll try and get back to you if required.
On Aug 13, 2016 5:23 PM, "moon soo Lee" <mo...@apache.org> wrote:
> Hi,
>
> Regarding java.lang.ClassNotFoundException: org.apache.hadoop.security.Use
> rGroupInformation$AuthenticationMethod error, I assume you're using
> master branch. (0.6.x branch shouldn't have this error)
> You can add "org.apache.hadoop:hadoop-common:2.7.2" in the Dependencies
> section of your interpreter setting on GUI, to remove this error.
>
> If you want to put your custom driver, you can set path of your jar in the
> local filesystem, in the Dependencies section of your interpreter setting,
> instead of "mysql:mysql-connector-java:5.1.38".
>
> Thanks,
> moon
>
> On Wed, Aug 10, 2016 at 4:25 AM Ram Shankar Yadav <
> ramshankaryadav@gmail.com> wrote:
>
>> Hi,
>> I was trying to create mysql interpreter using the reference document :
>> https://zeppelin.apache.org/docs/0.6.0/interpreter/jdbc.html
>>
>> I added required details for creating the interpreter:
>>
>>
>> I've also added the Credentials inside Credentials tab
>>
>>
>> But I'm getting this output:
>>
>>
>> text:
>>
>>> java.lang.ClassNotFoundException: org.apache.hadoop.security.
>>> UserGroupInformation$AuthenticationMethod
>>> at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
>>> at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
>>> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:331)
>>> at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
>>> at org.apache.zeppelin.jdbc.security.JDBCSecurityImpl.
>>> getAuthtype(JDBCSecurityImpl.java:71)
>>> at org.apache.zeppelin.jdbc.JDBCInterpreter.getConnection(
>>> JDBCInterpreter.java:217)
>>> at org.apache.zeppelin.jdbc.JDBCInterpreter.getStatement(
>>> JDBCInterpreter.java:275)
>>> at org.apache.zeppelin.jdbc.JDBCInterpreter.executeSql(
>>> JDBCInterpreter.java:346)
>>> at org.apache.zeppelin.jdbc.JDBCInterpreter.interpret(
>>> JDBCInterpreter.java:452)
>>> at org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(
>>> LazyOpenInterpreter.java:94)
>>> at org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$
>>> InterpretJob.jobRun(RemoteInterpreterServer.java:383)
>>> at org.apache.zeppelin.scheduler.Job.run(Job.java:176)
>>> at org.apache.zeppelin.scheduler.FIFOScheduler$1.run(
>>> FIFOScheduler.java:139)
>>> 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)
>>
>>
>> Also,
>> I realized that Zeppelin automatically creates localrepo folder and mysql
>> driver inside : local-repo/mysql/mysql-connector-java
>>
>> How can I use a custom JDBC driver? Where should I put my jdbc connector
>> jar files?
>>
>> Cheers,
>> Ram
>>
>
Re: Problem while creating mysql interpreter
Posted by Ram Shankar Yadav <ra...@gmail.com>.
Thanks Moon, appreciate your support!
I'll try and get back to you if required.
On Aug 13, 2016 5:23 PM, "moon soo Lee" <mo...@apache.org> wrote:
> Hi,
>
> Regarding java.lang.ClassNotFoundException: org.apache.hadoop.security.Use
> rGroupInformation$AuthenticationMethod error, I assume you're using
> master branch. (0.6.x branch shouldn't have this error)
> You can add "org.apache.hadoop:hadoop-common:2.7.2" in the Dependencies
> section of your interpreter setting on GUI, to remove this error.
>
> If you want to put your custom driver, you can set path of your jar in the
> local filesystem, in the Dependencies section of your interpreter setting,
> instead of "mysql:mysql-connector-java:5.1.38".
>
> Thanks,
> moon
>
> On Wed, Aug 10, 2016 at 4:25 AM Ram Shankar Yadav <
> ramshankaryadav@gmail.com> wrote:
>
>> Hi,
>> I was trying to create mysql interpreter using the reference document :
>> https://zeppelin.apache.org/docs/0.6.0/interpreter/jdbc.html
>>
>> I added required details for creating the interpreter:
>>
>>
>> I've also added the Credentials inside Credentials tab
>>
>>
>> But I'm getting this output:
>>
>>
>> text:
>>
>>> java.lang.ClassNotFoundException: org.apache.hadoop.security.
>>> UserGroupInformation$AuthenticationMethod
>>> at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
>>> at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
>>> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:331)
>>> at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
>>> at org.apache.zeppelin.jdbc.security.JDBCSecurityImpl.
>>> getAuthtype(JDBCSecurityImpl.java:71)
>>> at org.apache.zeppelin.jdbc.JDBCInterpreter.getConnection(
>>> JDBCInterpreter.java:217)
>>> at org.apache.zeppelin.jdbc.JDBCInterpreter.getStatement(
>>> JDBCInterpreter.java:275)
>>> at org.apache.zeppelin.jdbc.JDBCInterpreter.executeSql(
>>> JDBCInterpreter.java:346)
>>> at org.apache.zeppelin.jdbc.JDBCInterpreter.interpret(
>>> JDBCInterpreter.java:452)
>>> at org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(
>>> LazyOpenInterpreter.java:94)
>>> at org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$
>>> InterpretJob.jobRun(RemoteInterpreterServer.java:383)
>>> at org.apache.zeppelin.scheduler.Job.run(Job.java:176)
>>> at org.apache.zeppelin.scheduler.FIFOScheduler$1.run(
>>> FIFOScheduler.java:139)
>>> 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)
>>
>>
>> Also,
>> I realized that Zeppelin automatically creates localrepo folder and mysql
>> driver inside : local-repo/mysql/mysql-connector-java
>>
>> How can I use a custom JDBC driver? Where should I put my jdbc connector
>> jar files?
>>
>> Cheers,
>> Ram
>>
>
Re: Problem while creating mysql interpreter
Posted by moon soo Lee <mo...@apache.org>.
Hi,
Regarding java.lang.ClassNotFoundException: org.apache.hadoop.security.
UserGroupInformation$AuthenticationMethod error, I assume you're using
master branch. (0.6.x branch shouldn't have this error)
You can add "org.apache.hadoop:hadoop-common:2.7.2" in the Dependencies
section of your interpreter setting on GUI, to remove this error.
If you want to put your custom driver, you can set path of your jar in the
local filesystem, in the Dependencies section of your interpreter setting,
instead of "mysql:mysql-connector-java:5.1.38".
Thanks,
moon
On Wed, Aug 10, 2016 at 4:25 AM Ram Shankar Yadav <ra...@gmail.com>
wrote:
> Hi,
> I was trying to create mysql interpreter using the reference document :
> https://zeppelin.apache.org/docs/0.6.0/interpreter/jdbc.html
>
> I added required details for creating the interpreter:
>
>
> I've also added the Credentials inside Credentials tab
>
>
> But I'm getting this output:
>
>
> text:
>
>> java.lang.ClassNotFoundException:
>> org.apache.hadoop.security.UserGroupInformation$AuthenticationMethod
>> at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
>> at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
>> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:331)
>> at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
>> at
>> org.apache.zeppelin.jdbc.security.JDBCSecurityImpl.getAuthtype(JDBCSecurityImpl.java:71)
>> at
>> org.apache.zeppelin.jdbc.JDBCInterpreter.getConnection(JDBCInterpreter.java:217)
>> at
>> org.apache.zeppelin.jdbc.JDBCInterpreter.getStatement(JDBCInterpreter.java:275)
>> at
>> org.apache.zeppelin.jdbc.JDBCInterpreter.executeSql(JDBCInterpreter.java:346)
>> at
>> org.apache.zeppelin.jdbc.JDBCInterpreter.interpret(JDBCInterpreter.java:452)
>> at
>> org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:94)
>> at
>> org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:383)
>> at org.apache.zeppelin.scheduler.Job.run(Job.java:176)
>> at
>> org.apache.zeppelin.scheduler.FIFOScheduler$1.run(FIFOScheduler.java:139)
>> 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)
>
>
> Also,
> I realized that Zeppelin automatically creates localrepo folder and mysql
> driver inside : local-repo/mysql/mysql-connector-java
>
> How can I use a custom JDBC driver? Where should I put my jdbc connector
> jar files?
>
> Cheers,
> Ram
>
Re: Problem while creating mysql interpreter
Posted by moon soo Lee <mo...@apache.org>.
Hi,
Regarding java.lang.ClassNotFoundException: org.apache.hadoop.security.
UserGroupInformation$AuthenticationMethod error, I assume you're using
master branch. (0.6.x branch shouldn't have this error)
You can add "org.apache.hadoop:hadoop-common:2.7.2" in the Dependencies
section of your interpreter setting on GUI, to remove this error.
If you want to put your custom driver, you can set path of your jar in the
local filesystem, in the Dependencies section of your interpreter setting,
instead of "mysql:mysql-connector-java:5.1.38".
Thanks,
moon
On Wed, Aug 10, 2016 at 4:25 AM Ram Shankar Yadav <ra...@gmail.com>
wrote:
> Hi,
> I was trying to create mysql interpreter using the reference document :
> https://zeppelin.apache.org/docs/0.6.0/interpreter/jdbc.html
>
> I added required details for creating the interpreter:
>
>
> I've also added the Credentials inside Credentials tab
>
>
> But I'm getting this output:
>
>
> text:
>
>> java.lang.ClassNotFoundException:
>> org.apache.hadoop.security.UserGroupInformation$AuthenticationMethod
>> at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
>> at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
>> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:331)
>> at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
>> at
>> org.apache.zeppelin.jdbc.security.JDBCSecurityImpl.getAuthtype(JDBCSecurityImpl.java:71)
>> at
>> org.apache.zeppelin.jdbc.JDBCInterpreter.getConnection(JDBCInterpreter.java:217)
>> at
>> org.apache.zeppelin.jdbc.JDBCInterpreter.getStatement(JDBCInterpreter.java:275)
>> at
>> org.apache.zeppelin.jdbc.JDBCInterpreter.executeSql(JDBCInterpreter.java:346)
>> at
>> org.apache.zeppelin.jdbc.JDBCInterpreter.interpret(JDBCInterpreter.java:452)
>> at
>> org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:94)
>> at
>> org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:383)
>> at org.apache.zeppelin.scheduler.Job.run(Job.java:176)
>> at
>> org.apache.zeppelin.scheduler.FIFOScheduler$1.run(FIFOScheduler.java:139)
>> 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)
>
>
> Also,
> I realized that Zeppelin automatically creates localrepo folder and mysql
> driver inside : local-repo/mysql/mysql-connector-java
>
> How can I use a custom JDBC driver? Where should I put my jdbc connector
> jar files?
>
> Cheers,
> Ram
>