Can you attach the logs for jdbc? On Sat, Oct 22, 2016 at 7:43 AM, Lorenzo Peder <lorenzo.pe...@ds-iq.com> wrote:
> Hi all, > > > > I’m attempting to query drill (v 1.5) using zeppelin (v 0.6), but get the > same connection refused error (below) others have mentioned: ( > http://apache-zeppelin-users-incubating-mailing-list.75479. > x6.nabble.com/Drill-Connection-refused-error-td3975.html and > http://apache-zeppelin-users-incubating-mailing-list.75479. > x6.nabble.com/Drill-Connection-refused-error-td3975.html). > > I’ve been searching for a solution, but have been unsuccessful, it would > be greatly appreciated if someone could point me in the right direction. > > > > Currently I’m attempting a very simple query: > > %drill > > show tables > > > > Here are my %drill interpreter properties and values: > > common.max_count 1000 > > default.driver org.apache.drill.jdbc.Driver > > default.password > > default.url jdbc:drill:zk=<zk host>:2181/drill/drillbits1 > > default.user > > > > My dependencies artifact is org.apache.drill.exec:drill-jdbc:1.5.0 > > > > Here’s the connection refused error: > > java.net.ConnectException: Connection refused > > at java.net.PlainSocketImpl.socketConnect(Native Method) > > at java.net.AbstractPlainSocketImpl.doConnect( > AbstractPlainSocketImpl.java:350) > > at java.net.AbstractPlainSocketImpl.connectToAddress( > AbstractPlainSocketImpl.java:206) > > at java.net.AbstractPlainSocketImpl.connect( > AbstractPlainSocketImpl.java:188) > > at java.net.SocksSocketImpl.connect(SocksSocketImpl.java: > 392) > > at java.net.Socket.connect(Socket.java:589) > > at org.apache.thrift.transport. > TSocket.open(TSocket.java:182) > > at org.apache.zeppelin.interpreter.remote. > ClientFactory.create(ClientFactory.java:51) > > at org.apache.zeppelin.interpreter.remote. > ClientFactory.create(ClientFactory.java:37) > > at org.apache.commons.pool2.BasePooledObjectFactory. > makeObject(BasePooledObjectFactory.java:60) > > at org.apache.commons.pool2.impl.GenericObjectPool.create( > GenericObjectPool.java:861) > > at org.apache.commons.pool2.impl.GenericObjectPool. > borrowObject(GenericObjectPool.java:435) > > at org.apache.commons.pool2.impl.GenericObjectPool. > borrowObject(GenericObjectPool.java:363) > > at org.apache.zeppelin.interpreter.remote. > RemoteInterpreterProcess.getClient(RemoteInterpreterProcess.java:96) > > at org.apache.zeppelin.interpreter.remote. > RemoteInterpreter.init(RemoteInterpreter.java:216) > > at org.apache.zeppelin.interpreter.remote. > RemoteInterpreter.getFormType(RemoteInterpreter.java:383) > > at org.apache.zeppelin.interpreter.LazyOpenInterpreter. > getFormType(LazyOpenInterpreter.java:105) > > at org.apache.zeppelin.notebook. > Paragraph.jobRun(Paragraph.java:263) > > at org.apache.zeppelin.scheduler.Job.run(Job.java:176) > > at org.apache.zeppelin.scheduler. > RemoteScheduler$JobRunner.run(RemoteScheduler.java:329) > > at java.util.concurrent.Executors$RunnableAdapter. > call(Executors.java:511) > > at java.util.concurrent.FutureTask.run(FutureTask. > java:266) > > at java.util.concurrent.ScheduledThreadPoolExecutor$ > ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) > > at java.util.concurrent.ScheduledThreadPoolExecutor$ > ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) > > at java.util.concurrent.ThreadPoolExecutor.runWorker( > ThreadPoolExecutor.java:1142) > > at java.util.concurrent.ThreadPoolExecutor$Worker.run( > ThreadPoolExecutor.java:617) > > at java.lang.Thread.run(Thread.java:745) > > > > > > Thank you for any help, > > > > Lorenzo Peder > > > > > -- 이종열, Jongyoul Lee, 李宗烈 http://madeng.net
