I'm using zeppelin 0.9.0 preinstalled with AWS glue-libs docker image I installed jdbc using `bin/interperter-install.sh -n jdbc`
Jars: AthenaJDBC42.jar zeppelin-interpreter-shaded-0.9.0-preview1.jar Regards, Mohammed On Tue, Mar 16, 2021 at 10:31 AM Jeff Zhang <zjf...@gmail.com> wrote: > I didn't use athena before, but looking at the logs, it seems due to some > classes missing, which version of zeppelin do you use ? And do you install > the jdbc interpreter manually ? > > Mohammed Gaber <gab...@gmail.com> 于2021年3月16日周二 下午4:20写道： > >> Hello Jeff, >> >> Sorry for not being clear. >> It is a generic jdbc driver, I tried to use with zeppelin jdbc >> interpreter. >> While Page 17 shows some config examples, the docs doesn't mention >> zeppelin. >> >> my goal is to enable athena queries on zeppelin. >> so any advise is appreciated. >> >> On Tue, Mar 16, 2021 at 9:43 AM Jeff Zhang <zjf...@gmail.com> wrote: >> >>> It's 100 pages pdf, could you point which page mention the usage on >>> zeppelin ? >>> >>> Mohammed Gaber <gab...@gmail.com> 于2021年3月16日周二 下午3:21写道： >>> >>>> Hello All, >>>> >>>> I'm trying to access AWS Athena from Zeppelin. >>>> I've followed the Simba driver tutorial here: >>>> >>>> https://s3.amazonaws.com/athena-downloads/drivers/JDBC/SimbaAthenaJDBC-2.0.16.1000/docs/Simba+Athena+JDBC+Driver+Install+and+Configuration+Guide.pdf >>>> >>>> But when I try to execute a query I get the following error: >>>> ``` >>>> %athena >>>> show databases >>>> >>>> java.lang.NoClassDefFoundError: org/apache/zeppelin/util/PropertiesUtil >>>> at >>>> org.apache.zeppelin.jdbc.JDBCInterpreter.createConnectionPool(JDBCInterpreter.java:472) >>>> at >>>> org.apache.zeppelin.jdbc.JDBCInterpreter.getConnectionFromPool(JDBCInterpreter.java:488) >>>> at >>>> org.apache.zeppelin.jdbc.JDBCInterpreter.getConnection(JDBCInterpreter.java:512) >>>> at >>>> org.apache.zeppelin.jdbc.JDBCInterpreter.executeSql(JDBCInterpreter.java:698) >>>> at >>>> org.apache.zeppelin.jdbc.JDBCInterpreter.internalInterpret(JDBCInterpreter.java:877) >>>> at >>>> org.apache.zeppelin.interpreter.AbstractInterpreter.interpret(AbstractInterpreter.java:47) >>>> at >>>> org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:110) >>>> at >>>> org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:684) >>>> at >>>> org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:577) >>>> at org.apache.zeppelin.scheduler.Job.run(Job.java:172) at >>>> org.apache.zeppelin.scheduler.AbstractScheduler.runJob(AbstractScheduler.java:130) >>>> at >>>> org.apache.zeppelin.scheduler.ParallelScheduler.lambda$runJobInScheduler$0(ParallelScheduler.java:39) >>>> 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) Caused by: >>>> java.lang.ClassNotFoundException: org.apache.zeppelin.util.PropertiesUtil >>>> 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) ... 15 more >>>> java.lang.NoClassDefFoundError: org/apache/zeppelin/util/PropertiesUtil >>>> at >>>> org.apache.zeppelin.jdbc.JDBCInterpreter.createConnectionPool(JDBCInterpreter.java:472) >>>> at >>>> org.apache.zeppelin.jdbc.JDBCInterpreter.getConnectionFromPool(JDBCInterpreter.java:488) >>>> at >>>> org.apache.zeppelin.jdbc.JDBCInterpreter.getConnection(JDBCInterpreter.java:512) >>>> at >>>> org.apache.zeppelin.jdbc.JDBCInterpreter.executeSql(JDBCInterpreter.java:698) >>>> at >>>> org.apache.zeppelin.jdbc.JDBCInterpreter.internalInterpret(JDBCInterpreter.java:877) >>>> at >>>> org.apache.zeppelin.interpreter.AbstractInterpreter.interpret(AbstractInterpreter.java:47) >>>> at >>>> org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:110) >>>> at >>>> org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:684) >>>> at >>>> org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:577) >>>> at org.apache.zeppelin.scheduler.Job.run(Job.java:172) >>>> at >>>> org.apache.zeppelin.scheduler.AbstractScheduler.runJob(AbstractScheduler.java:130) >>>> at >>>> org.apache.zeppelin.scheduler.ParallelScheduler.lambda$runJobInScheduler$0(ParallelScheduler.java:39) >>>> 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) >>>> Caused by: java.lang.ClassNotFoundException: >>>> org.apache.zeppelin.util.PropertiesUtil >>>> 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) >>>> ... 15 more >>>> ``` >>>> >>>> How can I sort this error ? >>>> Thanks >>>> >>>> -- >>>> Regards, >>>> Mohammed GABER >>>> >>>> >>>> -- >>>> Regards, >>>> Mohammed GABER >>>> >>> >>> >>> -- >>> Best Regards >>> >>> Jeff Zhang >>> >> >> >> -- >> Regards, >> Mohammed GABER >> > > > -- > Best Regards > > Jeff Zhang > -- Regards, Mohammed GABER
