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
