Hi Jongyoul, Where may I find the jdbc logs within the log directories? Thanks, Lorenzo
From: Jongyoul Lee [mailto:jongy...@gmail.com] Sent: Saturday, October 22, 2016 9:00 AM To: users@zeppelin.apache.org Subject: Re: Zeppelin drill interpreter - connection refused Can you attach the logs for jdbc? On Sat, Oct 22, 2016 at 7:43 AM, Lorenzo Peder <lorenzo.pe...@ds-iq.com<mailto: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<http://java.net>.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) at java.net<http://java.net>.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) at java.net<http://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