See Jacques' earlier post about JDBC and Drill running in embedded mode. http://search-hadoop.com/m/fEbu4Dqor/JDBC&subj=Re+Using+Drill+with+JDBC+hangs
—Andries On Apr 8, 2015, at 5:05 PM, Chris R <[email protected]> wrote: > Hi > > I'm new to drill and am having difficulty establishing a jdbc connection > from squirrel. I see this issue has been raised previously but i haven't > been able to resolve the connection issue I am having. Any pointers would > be greatly appreciated. > > I'm interested in the ability of Drill to access text sources without the > etl overhead and am using the local file system only (no hadoop or mapr > sandbox). > > running Drill 0.8.0 using drill-jdbc-all-0.8.0.jar on Xubuntu 14.04 > filesystem is ext4 with Squirrel 3.6 and Java 1.7. > > Driver URL is: jdbc:drill:zk=localhost:2181 > > Alias URL is: jdbc:drill:zk=localhost:2181/drill/drillbits1 > > /* error message */ > Unexpected Error occurred attempting to open an SQL connection. > > /*stack trace*/ > java.util.concurrent.TimeoutException > at java.util.concurrent.FutureTask.get(FutureTask.java:201) > at > net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.awaitConnection(OpenConnectionCommand.java:132) > at > net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$100(OpenConnectionCommand.java:45) > at > net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$2.run(OpenConnectionCommand.java:115) > at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) > at java.util.concurrent.FutureTask.run(FutureTask.java:262) > 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) > > kind regards > Chris > > > -- > Chris Robertson > e : [email protected]
