Hello everyone,
I’m working on getting Apache Drill to work with Zeppelin via the Postgre/JDBC
interpreter. I got the interpreter to work with MySQL (yay!) and was able to
successfully query a MySQL database via Zeppelin.
I tried the same thing with Drill, and got the following error:
java.lang.NumberFormatException: For input string: ""
at
java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
at java.lang.Integer.parseInt(Integer.java:504)
at java.lang.Integer.valueOf(Integer.java:582)
at
org.apache.zeppelin.postgresql.PostgreSqlInterpreter.open(PostgreSqlInterpreter.java:143)
at
org.apache.zeppelin.interpreter.ClassloaderInterpreter.open(ClassloaderInterpreter.java:74)
at
org.apache.zeppelin.interpreter.LazyOpenInterpreter.open(LazyOpenInterpreter.java:68)
at
org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:92)
at
org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:276)
at org.apache.zeppelin.scheduler.Job.run(Job.java:170)
at
org.apache.zeppelin.scheduler.FIFOScheduler$1.run(FIFOScheduler.java:118)
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Drill is set up with no authentication and the settings I’m using in the
interpreter are:
postgresql.driver.name org.apache.drill.jdbc.Driver
postgresql.max.result
postgresql.password
postgresql.url jdbc:drill:drillbit=localhost:31010
postgresql.user
These settings do work in SQuirrelSQL to query Drill, so I’m reasonably certain
that the JDBC driver is installed and configured correctly. I’m using Zeppelin
0.5.5 and Drill 1.2 on a Mac. Any suggestions?
Thanks and keep up the good work?
— Charles
