Sure. Mind telling me how to? Do I download the zeppelin jar and replace it?
On Tue, Mar 16, 2021 at 10:52 AM Jeff Zhang <zjf...@gmail.com> wrote: > 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 > -- Regards, Mohammed GABER
