Re: Drill JDBC Interpreter: Connection Refused
Hi Kevin, this is very strange indeed. Could you please try to delete ./logs/* restart Zeppelin and try again, and then post 2 full log files, of both zeppelin server and drill interpreter I.e on gist or pastebin and share a link here? This should help to debug the situation. -- Alex On Fri, Jul 29, 2016, 01:17 Kevin Verhoeven <kevin.verhoe...@ds-iq.com> wrote: > Thanks Jongyoul, > > > > I tried your suggestion and used %drill with: > > > > drill.driver > > drill.url > > drill.user > > drill.password > > > > However, the query still failed with a “Connection refused” error. > > > > My drill.url is: jdbc:drill:zk=localhost:2181/drill/drillbits1 > > > > ZooKeeper and Drill both work, I’ve run many queries through Drill’s UI. > Only Zeppelin throws an error. > > > > Do you have any other suggestions? > > > > Thanks, > > > > Kevin > > > > The error I found in the log: > > > > ERROR [2016-07-28 09:13:37,639] ({Thread-97} > RemoteScheduler.java[getStatus]:256) - Can't get status information > > org.apache.zeppelin.interpreter.InterpreterException: > org.apache.thrift.transport.TTransportException: java.net.ConnectException: > Connection refused > > at > org.apache.zeppelin.interpreter.remote.ClientFactory.create(ClientFactory.java:53) > > 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.scheduler.RemoteScheduler$JobStatusPoller.getStatus(RemoteScheduler.java:254) > > at > org.apache.zeppelin.scheduler.RemoteScheduler$JobStatusPoller.run(RemoteScheduler.java:212) > > Caused by: org.apache.thrift.transport.TTransportException: > java.net.ConnectException: Connection refused > > at org.apache.thrift.transport.TSocket.open(TSocket.java:187) > > at > org.apache.zeppelin.interpreter.remote.ClientFactory.create(ClientFactory.java:51) > > ... 8 more > > Caused by: 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) > > ... 9 more > > > > *From:* Jongyoul Lee [mailto:jongy...@gmail.com] > *Sent:* Thursday, July 28, 2016 3:02 AM > > > *To:* users@zeppelin.apache.org > *Subject:* Re: Drill JDBC Interpreter: Connection Refused > > > > Hello Kevin, > > > > I've got to know what the problem is. > > > > If you are running query with "%drill ...", you can set > > > > drill.url > > drill.user > > drill.password > > > > If you set default.*, you should use "%jdbc ..." > > > > It's a little bit confused, and it will be improved by 0.7.0. > > > > Hope this help, > > Jongyoul > > > > On Thu, Jul 28, 2016 at 7:56 AM, Kevin Verhoeven < > kevin.verhoe...@ds-iq.com> wrote: > > I have the same problem. I am running Zeppelin version 0.6.0 and Drill > 1.5. When I attempt a Drill query from Zeppelin I receive a "Connection > refused" error. The query works successfully in Drill. My Interpreter > configurations: > > > > default.url: jdbc:drill:zk=my*ServerName*:8121/drill/drillbits1 > > default.user: > > default.password: > > > > Dependency: org.apache.drill.exec:drill-jdbc:1.5.0 > > > > The query I run is very simple, but the Zeppelin paragraph runs for a few > seconds and then returns the connection refused error. I pasted the full > error below. > > > > Any recommendations? > > > > Thanks! > > > > Kevin
RE: Drill JDBC Interpreter: Connection Refused
Thanks Jongyoul, I tried your suggestion and used %drill with: drill.driver drill.url drill.user drill.password However, the query still failed with a “Connection refused” error. My drill.url is: jdbc:drill:zk=localhost:2181/drill/drillbits1 ZooKeeper and Drill both work, I’ve run many queries through Drill’s UI. Only Zeppelin throws an error. Do you have any other suggestions? Thanks, Kevin The error I found in the log: ERROR [2016-07-28 09:13:37,639] ({Thread-97} RemoteScheduler.java[getStatus]:256) - Can't get status information org.apache.zeppelin.interpreter.InterpreterException: org.apache.thrift.transport.TTransportException: java.net.ConnectException: Connection refused at org.apache.zeppelin.interpreter.remote.ClientFactory.create(ClientFactory.java:53) 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.scheduler.RemoteScheduler$JobStatusPoller.getStatus(RemoteScheduler.java:254) at org.apache.zeppelin.scheduler.RemoteScheduler$JobStatusPoller.run(RemoteScheduler.java:212) Caused by: org.apache.thrift.transport.TTransportException: java.net.ConnectException: Connection refused at org.apache.thrift.transport.TSocket.open(TSocket.java:187) at org.apache.zeppelin.interpreter.remote.ClientFactory.create(ClientFactory.java:51) ... 8 more Caused by: 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) ... 9 more From: Jongyoul Lee [mailto:jongy...@gmail.com] Sent: Thursday, July 28, 2016 3:02 AM To: users@zeppelin.apache.org Subject: Re: Drill JDBC Interpreter: Connection Refused Hello Kevin, I've got to know what the problem is. If you are running query with "%drill ...", you can set drill.url drill.user drill.password If you set default.*, you should use "%jdbc ..." It's a little bit confused, and it will be improved by 0.7.0. Hope this help, Jongyoul On Thu, Jul 28, 2016 at 7:56 AM, Kevin Verhoeven <kevin.verhoe...@ds-iq.com<mailto:kevin.verhoe...@ds-iq.com>> wrote: I have the same problem. I am running Zeppelin version 0.6.0 and Drill 1.5. When I attempt a Drill query from Zeppelin I receive a "Connection refused" error. The query works successfully in Drill. My Interpreter configurations: default.url: jdbc:drill:zk=myServerName:8121/drill/drillbits1 default.user: default.password: Dependency: org.apache.drill.exec:drill-jdbc:1.5.0 The query I run is very simple, but the Zeppelin paragraph runs for a few seconds and then returns the connection refused error. I pasted the full error below. Any recommendations? Thanks! Kevin Zeppelin Paragraph: %drill SELECT * FROM asdf LIMIT 100 Zeppelin 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
Re: Drill JDBC Interpreter: Connection Refused
Hello, It looks like a kind of initialization error. Could you tell me your script starting from %? And interpreter logs which is located under logs/ will help solve this error. Hope this help, JL On Wednesday, 13 July 2016, Krishnaprasad A Swrote: > hi, > I'm trying to create a drill interpreter in zeppelin. > > *drill.url = jdbc:drill:zk=:2181/drill/drillbits1drill.driver = > org.apache.drill.jdbc.Driver* > my drillbit runs on the same server as of zeppelin. > > Added the dependency 'apache-drill-1.7.0/jars/drill-jdbc-all-1.7.0.jar' in > zeppelin ui. > I'm the getting the following error while running a sample SQL from > zeppelin, > > ERROR [2016-07-12 01:11:41,946] ({pool-1-thread-4} > NotebookServer.java[afterStatusChange]:1135) - Error > org.apache.zeppelin.interpreter.InterpreterException: > org.apache.zeppelin.interpreter.InterpreterException: > org.apache.thrift.transport.TTransportException: java.net.ConnectException: > Connection refused > at > org.apache.zeppelin.interpreter.remote.RemoteInterpreter.init(RemoteInterpreter.java:165) > at > org.apache.zeppelin.interpreter.remote.RemoteInterpreter.getFormType(RemoteInterpreter.java:328) > at > org.apache.zeppelin.interpreter.LazyOpenInterpreter.getFormType(LazyOpenInterpreter.java:105) > at > org.apache.zeppelin.notebook.Paragraph.jobRun(Paragraph.java:260) > at org.apache.zeppelin.scheduler.Job.run(Job.java:176) > at > org.apache.zeppelin.scheduler.RemoteScheduler$JobRunner.run(RemoteScheduler.java:328) > at > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) > at > java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) > at java.util.concurrent.FutureTask.run(FutureTask.java:166) > at > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178) > at > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) > at java.lang.Thread.run(Thread.java:722) > Caused by: org.apache.zeppelin.interpreter.InterpreterException: > org.apache.thrift.transport.TTransportException: java.net.ConnectException: > Connection refused > at > org.apache.zeppelin.interpreter.remote.ClientFactory.create(ClientFactory.java:53) > 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:184) > at > org.apache.zeppelin.interpreter.remote.RemoteInterpreter.init(RemoteInterpreter.java:163) > ... 13 more > Caused by: org.apache.thrift.transport.TTransportException: > java.net.ConnectException: Connection refused > at org.apache.thrift.transport.TSocket.open(TSocket.java:187) > at > org.apache.zeppelin.interpreter.remote.ClientFactory.create(ClientFactory.java:51) > ... 20 more > Caused by: java.net.ConnectException: Connection refused > > reference used https://community.mapr.com/docs/DOC-1493 > > -- 이종열, Jongyoul Lee, 李宗烈 http://madeng.net