You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@zeppelin.apache.org by Lorenzo Peder <Lo...@ds-iq.com> on 2016/10/21 22:43:16 UTC
Zeppelin drill interpreter - connection refused
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
Re: Zeppelin drill interpreter - connection refused
Posted by Jongyoul Lee <jo...@gmail.com>.
Generally, ${ZEPPELIN_HOME}/logs/...
On Tue, Oct 25, 2016 at 3:18 AM, Lorenzo Peder <Lo...@ds-iq.com>
wrote:
> Hi Jongyoul,
>
> Where may I find the jdbc logs within the log directories?
>
>
>
> Thanks,
>
> Lorenzo
>
>
>
> *From:* Jongyoul Lee [mailto:jongyoul@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 <Lo...@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
>
--
이종열, Jongyoul Lee, 李宗烈
http://madeng.net
RE: Zeppelin drill interpreter - connection refused
Posted by Lorenzo Peder <Lo...@ds-iq.com>.
Hi Jongyoul,
Where may I find the jdbc logs within the log directories?
Thanks,
Lorenzo
From: Jongyoul Lee [mailto:jongyoul@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 <Lo...@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
Re: Zeppelin drill interpreter - connection refused
Posted by Jongyoul Lee <jo...@gmail.com>.
Can you attach the logs for jdbc?
On Sat, Oct 22, 2016 at 7:43 AM, Lorenzo Peder <Lo...@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