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
