Resending this since the original response went only to Teemu. Developers may want to look into the potential bug discussed below. - Paul Hi Teemu, Thanks for posting the detailed information. Very helpful. You are running Sqlline with an embedded Drillbit (that's what drill-embedded) does. I suspect that you are hitting an issue due to the way that Drill builds the JDBC driver. I'll explain the issue (for the benefit of the Drill folks) then suggest a solution for you. Drill builds a JDBC driver that includes all of Drill. But, Drill is huge (200+ MB), we try to create a dependency-reduced jar. It seems that we are not removing so much from the jar that it can no longer run an embedded server. The problem in this case is that the jar relocates the package with DrillConfig, but it looks like some other part of the code is not adjusted. From the dependency-reduced-pom.xml file:
<relocations> ... <relocation> <pattern>org.apache.drill.common.</pattern> <shadedPattern>oadd.org.apache.drill.common.</shadedPattern> </relocation> The stack trace you provided shows that the code tries to reference DrillConfig in its original location: org.apache.drill.common.config.DrillConfig. But, because of the relocation, it should be referenced as add.org.apache.drill.common.config.DrillConfig. This is clearly a bug. Would be great if someone (Kunal?) could verify this and file a bug. In the mean time, I'd suggest you simply run an actual Drill server, then connect Sqlline to that server. You'll want to run as a server anyway to use the Web UI, to see query profiles, to change your storage profiles, and so on. A quick check of the documentation suggests we don't actually write up this use case. (Suggestion to Bridget: we should.) Here is what to do: 1. Ensure you have a Zookeeper running on your machine. See [1] for hints. You only need one ZK on your laptop.2. Start Drill with drillbit.sh start. (See the distributed mode docs for the other commands.)3. Start Sqlline as explained in [2] The "out of the box" Drill config uses the "out of the box" ZK config, so you should not have to do any setup. Seen the docs for how to use the web console and how to stop your Drill server. Another key advantage of this mode is that you can better control memory, which is important as you run larger or more complex queries. Thanks, - Paul [1] http://drill.apache.org/docs/distributed-mode-prerequisites/[2] http://drill.apache.org/docs/starting-drill-in-distributed-mode/ On Friday, January 26, 2018, 12:32:13 AM PST, [email protected] <[email protected]> wrote: Hi all, I'm trying to follow the 10 minutes tutorial and I get stuck right away... https://drill.apache.org/docs/drill-in-10-minutes/ Everything works just fine with my ubuntu box, but with osx, this is all I get $ bin/drill-embedded Java HotSpot(TM) 64-Bit Server VM warning: Ignoring option MaxPermSize; support was removed in 8.0 sun/misc/VM apache drill 1.12.0 "just drill it" 0: jdbc:drill:zk=local> SELECT * FROM cp.`employee.json` LIMIT 3; No current connection 0: jdbc:drill:zk=local> !list 1 active connection: #0 closed jdbc:drill:zk=local 0: jdbc:drill:zk=local> !quit java.lang.NoClassDefFoundError: Could not initialize class org.apache.drill.common.config.DrillConfig at org.apache.drill.jdbc.impl.DrillConnectionImpl.<init>(DrillConnectionImpl.java:124) at org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:72) at org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:69) at org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:144) at org.apache.drill.jdbc.Driver.connect(Driver.java:72) at sqlline.DatabaseConnection.connect(DatabaseConnection.java:167) at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:213) at sqlline.Commands.close(Commands.java:925) at sqlline.Commands.quit(Commands.java:889) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:564) at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:36) at sqlline.SqlLine.dispatch(SqlLine.java:742) at sqlline.SqlLine.begin(SqlLine.java:621) at sqlline.SqlLine.start(SqlLine.java:375) at sqlline.SqlLine.main(SqlLine.java:268) Exception in thread "main" java.lang.NoClassDefFoundError: Could not initialize class org.apache.drill.common.config.DrillConfig at org.apache.drill.jdbc.impl.DrillConnectionImpl.<init>(DrillConnectionImpl.java:124) at org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:72) at org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:69) at org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:144) at org.apache.drill.jdbc.Driver.connect(Driver.java:72) at sqlline.DatabaseConnection.connect(DatabaseConnection.java:167) at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:213) at sqlline.Commands.close(Commands.java:925) at sqlline.Commands.closeall(Commands.java:899) at sqlline.SqlLine.begin(SqlLine.java:649) at sqlline.SqlLine.start(SqlLine.java:375) at sqlline.SqlLine.main(SqlLine.java:268) What's going on here? Am I missing something obvious? All help is appreciated! Teemu
