drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jacques Nadeau <jacq...@apache.org>
Subject Re: Request for a wiki on programatically submitting queries to drill
Date Sat, 04 Apr 2015 17:39:18 GMT
It looks like you are trying to start up an embedded Drillbit inside your
application.  If so, you'll need to use a complete JDBC driver (rather than
the remote-only driver).

We provide two different JDBC drivers.  The standalone jdbc-all driver is
designed to be a remote driver.  As such, you must have zookeeper and a
separate Drill daemon up and running to leverage it.  If you want to embed
a Drillbit inside your application, you'll need to source the same
classpath that the drillbit.sh start-up script sources.

Which was your goal?

On Sat, Apr 4, 2015 at 5:42 AM, Tamil selvan R.S <tamil.3758@gmail.com>

> I tried to use the jdbc jar that gets shipped in with drill and ended up in
> this state finally,
> Connecting to database...
> java.sql.SQLException: Running Drill in embedded mode using the JDBC jar
> alone is not supported.
> at
> org.apache.drill.jdbc.DrillConnectionImpl.<init>(DrillConnectionImpl.java:67)
> at
> org.apache.drill.jdbc.DrillJdbc41Factory$DrillJdbc41Connection.<init>(DrillJdbc41Factory.java:88)
> at
> org.apache.drill.jdbc.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:57)
> at
> org.apache.drill.jdbc.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:43)
> at org.apache.drill.jdbc.DrillFactory.newConnection(DrillFactory.java:51)
> at
> net.hydromatic.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:135)
> at java.sql.DriverManager.getConnection(DriverManager.java:571)
> at java.sql.DriverManager.getConnection(DriverManager.java:233)
> at DrillTry.main(DrillTry.java:32)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at com.intellij.rt.execution.application.AppMain.main(AppMain.java:120)
> Goodbye!
> On Further research landed on the issue below
> *https://issues.apache.org/jira/browse/DRILL-1409
> <https://issues.apache.org/jira/browse/DRILL-1409>*
> What should be done to get of this state? Am I supposed to include all the
> jars inside jar folder? Including 3rd Party? A detailed wiki on this topic
> would be of great use [Given few pointers I can manage to create one as
> well], as programatically querying the data is a most common use case and
> the REST based solution looks a round about.
> Regards,
> Tamil.s

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message