You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@zeppelin.apache.org by Krishnaprasad A S <kr...@flytxt.com> on 2016/07/12 19:12:43 UTC

Fwd: Drill JDBC Interpreter: Connection Refused

hi,
I'm trying to create a drill interpreter in zeppelin.

*drill.url = jdbc:drill:zk=<host>: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

Re: Drill JDBC Interpreter: Connection Refused

Posted by Alexander Bezzubov <bz...@apache.org>.
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 <Ke...@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:jongyoul@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.Verhoeven@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
>
>
>
> 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.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)
>
>
>
> *From:* Jongyoul Lee [mailto:jongyoul@gmail.com]
> *Sent:* Tuesday, July 12, 2016 10:53 PM
> *To:* users@zeppelin.apache.org
> *Subject:* Re: Drill JDBC Interpreter: Connection Refused
>
>
>
> Hello,
>
>
>
> It seem not to launch remote Interpreter properly. Which version are you
> using? I've found the error file and couldn't find the version which you
> are using
>
>
>
> JL
>
>
>
> On Wed, Jul 13, 2016 at 2:32 PM, Krishnaprasad A S <
> krishna.prasad@flytxt.com> wrote:
>
> I tried with,
>  %jdbc(drill)
>
> %drill
>
> %drill(jdbc)
>
> Currently I made the drill interpretor as the default one and ran the sql
> without using a %drill,
> select count(*) from `dfs`.`POC/Sample10000.csv`
>
>  Please find attached error log.
>
>
>
>
>
> On Wed, Jul 13, 2016 at 5:26 AM, Jongyoul Lee <jo...@gmail.com> wrote:
>
> 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 S <kr...@flytxt.com>
> wrote:
>
> hi,
> I'm trying to create a drill interpreter in zeppelin.
>
> *drill.url = jdbc:drill:zk=<host>:2181/drill/drillbits1 drill.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
>
>
>
>
>
> --
>
> Krishnaprasad A S
> Lead Engineer
> Flytxt
> Skype: krishnaprasadas
> M: +91 8907209454 | O: +91 471.3082753 <%2B91%20471.3082753> | F: +91
> 471.2700202
> www.flytxt.com | Visit our blog <http://blog.flytxt.com/> | Follow us
> <http://www.twitter.com/flytxt> | Connect on LinkedIn
> <http://www.linkedin.com/company/22166?goback=%2Efcs_GLHD_flytxt_false_*2_*2_*2_*2_*2_*2_*2_*2_*2_*2_*2_*2&trk=ncsrch_hits>
>
>
>
>
>
> --
>
> 이종열, Jongyoul Lee, 李宗烈
>
> http://madeng.net
>
>
>
>
>
> --
>
> 이종열, Jongyoul Lee, 李宗烈
>
> http://madeng.net
>

RE: Drill JDBC Interpreter: Connection Refused

Posted by Kevin Verhoeven <Ke...@ds-iq.com>.
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:jongyoul@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 <Ke...@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.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)

From: Jongyoul Lee [mailto:jongyoul@gmail.com<ma...@gmail.com>]
Sent: Tuesday, July 12, 2016 10:53 PM
To: users@zeppelin.apache.org<ma...@zeppelin.apache.org>
Subject: Re: Drill JDBC Interpreter: Connection Refused

Hello,

It seem not to launch remote Interpreter properly. Which version are you using? I've found the error file and couldn't find the version which you are using

JL

On Wed, Jul 13, 2016 at 2:32 PM, Krishnaprasad A S <kr...@flytxt.com>> wrote:
I tried with,
 %jdbc(drill)
%drill
%drill(jdbc)
Currently I made the drill interpretor as the default one and ran the sql without using a %drill,
select count(*) from `dfs`.`POC/Sample10000.csv`
 Please find attached error log.


On Wed, Jul 13, 2016 at 5:26 AM, Jongyoul Lee <jo...@gmail.com>> wrote:
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 S <kr...@flytxt.com>> wrote:
hi,
I'm trying to create a drill interpreter in zeppelin.
drill.url = jdbc:drill:zk=<host>:2181/drill/drillbits1
drill.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



--
Krishnaprasad A S
Lead Engineer
Flytxt
Skype: krishnaprasadas
M: +91 8907209454<tel:%2B91%208907209454> | O: +91 471.3082753<tel:%2B91%20471.3082753> | F: +91 471.2700202<tel:%2B91%20471.2700202>
www.flytxt.com<http://www.flytxt.com/> | Visit our blog<http://blog.flytxt.com/> | Follow us<http://www.twitter.com/flytxt> | Connect on LinkedIn<http://www.linkedin.com/company/22166?goback=%2Efcs_GLHD_flytxt_false_*2_*2_*2_*2_*2_*2_*2_*2_*2_*2_*2_*2&trk=ncsrch_hits>



--
이종열, Jongyoul Lee, 李宗烈
http://madeng.net



--
이종열, Jongyoul Lee, 李宗烈
http://madeng.net

Re: Drill JDBC Interpreter: Connection Refused

Posted by Jongyoul Lee <jo...@gmail.com>.
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 <Ke...@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
>
>
>
> 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.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)
>
>
>
> *From:* Jongyoul Lee [mailto:jongyoul@gmail.com]
> *Sent:* Tuesday, July 12, 2016 10:53 PM
> *To:* users@zeppelin.apache.org
> *Subject:* Re: Drill JDBC Interpreter: Connection Refused
>
>
>
> Hello,
>
>
>
> It seem not to launch remote Interpreter properly. Which version are you
> using? I've found the error file and couldn't find the version which you
> are using
>
>
>
> JL
>
>
>
> On Wed, Jul 13, 2016 at 2:32 PM, Krishnaprasad A S <
> krishna.prasad@flytxt.com> wrote:
>
> I tried with,
>  %jdbc(drill)
>
> %drill
>
> %drill(jdbc)
>
> Currently I made the drill interpretor as the default one and ran the sql
> without using a %drill,
> select count(*) from `dfs`.`POC/Sample10000.csv`
>
>  Please find attached error log.
>
>
>
>
>
> On Wed, Jul 13, 2016 at 5:26 AM, Jongyoul Lee <jo...@gmail.com> wrote:
>
> 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 S <kr...@flytxt.com>
> wrote:
>
> hi,
> I'm trying to create a drill interpreter in zeppelin.
>
> *drill.url = jdbc:drill:zk=<host>:2181/drill/drillbits1 drill.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
>
>
>
>
>
> --
>
> Krishnaprasad A S
> Lead Engineer
> Flytxt
> Skype: krishnaprasadas
> M: +91 8907209454 | O: +91 471.3082753 <%2B91%20471.3082753> | F: +91
> 471.2700202
> www.flytxt.com | Visit our blog <http://blog.flytxt.com/> | Follow us
> <http://www.twitter.com/flytxt> | Connect on LinkedIn
> <http://www.linkedin.com/company/22166?goback=%2Efcs_GLHD_flytxt_false_*2_*2_*2_*2_*2_*2_*2_*2_*2_*2_*2_*2&trk=ncsrch_hits>
>
>
>
>
>
> --
>
> 이종열, Jongyoul Lee, 李宗烈
>
> http://madeng.net
>



-- 
이종열, Jongyoul Lee, 李宗烈
http://madeng.net

RE: Drill JDBC Interpreter: Connection Refused

Posted by Kevin Verhoeven <Ke...@ds-iq.com>.
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.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)

From: Jongyoul Lee [mailto:jongyoul@gmail.com]
Sent: Tuesday, July 12, 2016 10:53 PM
To: users@zeppelin.apache.org
Subject: Re: Drill JDBC Interpreter: Connection Refused

Hello,

It seem not to launch remote Interpreter properly. Which version are you using? I've found the error file and couldn't find the version which you are using

JL

On Wed, Jul 13, 2016 at 2:32 PM, Krishnaprasad A S <kr...@flytxt.com>> wrote:
I tried with,
 %jdbc(drill)
%drill
%drill(jdbc)
Currently I made the drill interpretor as the default one and ran the sql without using a %drill,
select count(*) from `dfs`.`POC/Sample10000.csv`
 Please find attached error log.


On Wed, Jul 13, 2016 at 5:26 AM, Jongyoul Lee <jo...@gmail.com>> wrote:
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 S <kr...@flytxt.com>> wrote:
hi,
I'm trying to create a drill interpreter in zeppelin.
drill.url = jdbc:drill:zk=<host>:2181/drill/drillbits1
drill.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



--
Krishnaprasad A S
Lead Engineer
Flytxt
Skype: krishnaprasadas
M: +91 8907209454<tel:%2B91%208907209454> | O: +91 471.3082753<tel:%2B91%20471.3082753> | F: +91 471.2700202<tel:%2B91%20471.2700202>
www.flytxt.com<http://www.flytxt.com/> | Visit our blog<http://blog.flytxt.com/> | Follow us<http://www.twitter.com/flytxt> | Connect on LinkedIn<http://www.linkedin.com/company/22166?goback=%2Efcs_GLHD_flytxt_false_*2_*2_*2_*2_*2_*2_*2_*2_*2_*2_*2_*2&trk=ncsrch_hits>



--
이종열, Jongyoul Lee, 李宗烈
http://madeng.net

Re: Drill JDBC Interpreter: Connection Refused

Posted by Jongyoul Lee <jo...@gmail.com>.
Hello,

It seem not to launch remote Interpreter properly. Which version are you
using? I've found the error file and couldn't find the version which you
are using

JL

On Wed, Jul 13, 2016 at 2:32 PM, Krishnaprasad A S <
krishna.prasad@flytxt.com> wrote:

> I tried with,
>  %jdbc(drill)
> %drill
> %drill(jdbc)
>
> Currently I made the drill interpretor as the default one and ran the sql
> without using a %drill,
> select count(*) from `dfs`.`POC/Sample10000.csv`
>  Please find attached error log.
>
>
> On Wed, Jul 13, 2016 at 5:26 AM, Jongyoul Lee <jo...@gmail.com> wrote:
>
>> 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 S <kr...@flytxt.com>
>> wrote:
>>
>>> hi,
>>> I'm trying to create a drill interpreter in zeppelin.
>>>
>>> *drill.url = jdbc:drill:zk=<host>: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
>>
>>
>
>
> --
> Krishnaprasad A S
> Lead Engineer
> Flytxt
> Skype: krishnaprasadas
> M: +91 8907209454 | O: +91 471.3082753 | F: +91 471.2700202
> www.flytxt.com | Visit our blog <http://blog.flytxt.com/> | Follow us
> <http://www.twitter.com/flytxt> | Connect on LinkedIn
> <http://www.linkedin.com/company/22166?goback=%2Efcs_GLHD_flytxt_false_*2_*2_*2_*2_*2_*2_*2_*2_*2_*2_*2_*2&trk=ncsrch_hits>
>



-- 
이종열, Jongyoul Lee, 李宗烈
http://madeng.net

Re: Drill JDBC Interpreter: Connection Refused

Posted by Krishnaprasad A S <kr...@flytxt.com>.
I tried with,
 %jdbc(drill)
%drill
%drill(jdbc)

Currently I made the drill interpretor as the default one and ran the sql
without using a %drill,
select count(*) from `dfs`.`POC/Sample10000.csv`
 Please find attached error log.


On Wed, Jul 13, 2016 at 5:26 AM, Jongyoul Lee <jo...@gmail.com> wrote:

> 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 S <kr...@flytxt.com>
> wrote:
>
>> hi,
>> I'm trying to create a drill interpreter in zeppelin.
>>
>> *drill.url = jdbc:drill:zk=<host>: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
>
>


-- 
Krishnaprasad A S
Lead Engineer
Flytxt
Skype: krishnaprasadas
M: +91 8907209454 | O: +91 471.3082753 | F: +91 471.2700202
www.flytxt.com | Visit our blog <http://blog.flytxt.com/> | Follow us
<http://www.twitter.com/flytxt> | Connect on LinkedIn
<http://www.linkedin.com/company/22166?goback=%2Efcs_GLHD_flytxt_false_*2_*2_*2_*2_*2_*2_*2_*2_*2_*2_*2_*2&trk=ncsrch_hits>

Re: Drill JDBC Interpreter: Connection Refused

Posted by Jongyoul Lee <jo...@gmail.com>.
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 S <kr...@flytxt.com>
wrote:

> hi,
> I'm trying to create a drill interpreter in zeppelin.
>
> *drill.url = jdbc:drill:zk=<host>: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