Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

HDP 2.5 & Zeppelin 06.0 can support mysql interpreter

Highlighted

HDP 2.5 & Zeppelin 06.0 can support mysql interpreter

Explorer

when i create a new interpreter , ther properties like this :

namevalue
common.max_count
default.drivercom.mysql.jdbc.Driver
default.password
default.urljdbc:mysql://172.171.16.237:3306/
default.userroot

when i create new notebook, and run paragraph , there something error like this:

Run SQL command 'show databases;' INFO [2017-04-27 14:44:20,141] ({pool-2-thread-2} JDBCInterpreter.java[interpret]:440) - PropertyKey: default, SQL command: 'show databases;' INFO [2017-04-27 14:44:20,142] ({pool-2-thread-2} JDBCInterpreter.java[getConnection]:213) - com.mysql.jdbc.Driver ERROR [2017-04-27 14:44:20,142] ({pool-2-thread-2} Job.java[run]:189) - Job failed java.lang.NoClassDefFoundError: org/apache/hadoop/security/UserGroupInformation$AuthenticationMethod at org.apache.zeppelin.jdbc.security.JDBCSecurityImpl.getAuthtype(JDBCSecurityImpl.java:66) 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:336) at org.apache.zeppelin.jdbc.JDBCInterpreter.interpret(JDBCInterpreter.java:442) at org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:94) at org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:341) at org.apache.zeppelin.scheduler.Job.run(Job.java:176) at org.apache.zeppelin.scheduler.ParallelScheduler$JobRunner.run(ParallelScheduler.java:162) 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)

1 REPLY 1
Highlighted

Re: HDP 2.5 & Zeppelin 06.0 can support mysql interpreter

@Ye Jun

1) Is it a secured cluster?

2) Can you please provide a screenshot of the zeppelin jdbc interpreter dependencies from interpreters UI page?

Don't have an account?
Coming from Hortonworks? Activate your account here