Not sure how AWS glue-libs docker image install zeppelin, it looks like it is using a preview version of 0.9.0, could you use the official 0.9.0 release ?
Mohammed Gaber <gab...@gmail.com> 于2021年3月16日周二 下午4:39写道： > 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 > -- Best Regards Jeff Zhang
