Looks like you are using Drill in embedded mode. Instead of trying to connect to ZK (not available in embedded mode) rather connect to the drillbit directly.
Example below sqlline -u jdbc:drill:drillbit=localhost Basically replace zk=localhost with drillbit=localhost See if that works for you. —Andries > On Nov 2, 2015, at 9:48 AM, Martin Senne <martin.se...@googlemail.com> wrote: > > Hi all, > > Situation > > following the details on > https://drill.apache.org/docs/using-the-jdbc-driver/ > I'm trying to connect > > - with a simple JDBC Client (based on the code on bottom of > "using-the-jdbc-driver"-page) > - using the Drill JDBC Driver( > *./jars/jdbc-driver/drill-jdbc-all-1.2.0.jar* ) in classpath > - to a locally running embedded drill instance. ( started via > ./bin/drill-embedded ) > - with connection url:* jdbc:drill:schema=P3.public;zk=local* > - Drill Storage P3 is of type "jdbc" and connects to a PostgreSQL DB. > (Remark: Storage P3 is working properly and can be queried in embedded > Drill shell as expected) > > Problem > > On startup of the simple JDBC Client, I encounter: > > 17:36:44 DEBUG FormatPluginConfigBase: Found 0 format plugin configuration > classes: . > 17:36:44 DEBUG DrillConfig: DrillConfig object initialized. > [error] (run-main-0) java.lang.NoClassDefFoundError: > oadd/org/apache/drill/exec/store/sys/PStoreProvider > java.lang.NoClassDefFoundError: > *oadd/org/apache/drill/exec/store/sys/PStoreProvider* > at > org.apache.drill.jdbc.impl.DrillConnectionImpl.<init>(DrillConnectionImpl.java:100) > at > org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:66) > at > org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:69) > at > oadd.net.hydromatic.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:126) > at org.apache.drill.jdbc.Driver.connect(Driver.java:72) > at java.sql.DriverManager.getConnection(DriverManager.java:664) > at java.sql.DriverManager.getConnection(DriverManager.java:247) > > Analysis > > - Opening drill-jdbc-all-1.2.0 .jar the path > /oadd/org/apache/drill/exec/... is missing in the jar. > - BTW: The same holds for a freshly built drill-1.3.0-snapshot > > Questions > > - Is it reasonable (and intented) to connect to an embedded drill > instance via the JDBC client, like I do? If not, what are the alternatives? > - Is it a bug (or maybe unintended), that within ./*exec/jdbc-all/pom.xml > *in the <filter>-section of the shade plugin, "exec/store" (line 408) is > filtered? > <exclude>org/apache/drill/exec/store/**</exclude> > > Thx for help in advance, > > Martin
