You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@zeppelin.apache.org by Abhi Basu <90...@gmail.com> on 2017/11/17 16:39:21 UTC
Impala configs for Zeppelin Interpreter
Hive works fine but impala does not.
Interpreter setting:
common.max_count 1000
default.driver org.apache.hive.jdbc.HiveDriver
default.password
default.url jdbc:hive2://hadoop-nn2:10000
default.user hive
impala.driver org.apache.hive.jdbc.HiveDriver
impala.password
impala.url jdbc:hive2://hadoop-nn2:20150/;auth=noSasl
impala.user impala
CDH 5.13 cluster - 6 node, Zeppelin 0.73 binaries
Logs:
ERROR, exception: null, result: %text java.sql.SQLException: Could not open
client transport with JDBC Uri: jdbc:hive2://
hadoop-nn2.esolocal.com:20150/;auth=noSasl: java.net.ConnectException:
Connection refused (Connection refused)
at
org.apache.hive.jdbc.HiveConnection.openTransport(HiveConnection.java:215)
at org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:163)
at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:105)
at java.sql.DriverManager.getConnection(DriverManager.java:571)
at java.sql.DriverManager.getConnection(DriverManager.java:187)
at
org.apache.commons.dbcp2.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:79)
at
org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:205)
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.commons.dbcp2.PoolingDriver.connect(PoolingDriver.java:129)
at java.sql.DriverManager.getConnection(DriverManager.java:571)
at java.sql.DriverManager.getConnection(DriverManager.java:233)
at
org.apache.zeppelin.jdbc.JDBCInterpreter.getConnectionFromPool(JDBCInterpreter.java:360)
at
org.apache.zeppelin.jdbc.JDBCInterpreter.getConnection(JDBCInterpreter.java:378)
at
org.apache.zeppelin.jdbc.JDBCInterpreter.executeSql(JDBCInterpreter.java:570)
at
org.apache.zeppelin.jdbc.JDBCInterpreter.interpret(JDBCInterpreter.java:709)
at
org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:97)
at
org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:498)
at org.apache.zeppelin.scheduler.Job.run(Job.java:175)
at
org.apache.zeppelin.scheduler.ParallelScheduler$JobRunner.run(ParallelScheduler.java:162)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:473)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
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:1152)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:622)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.apache.thrift.transport.TTransportException:
java.net.ConnectException: Connection refused (Connection refused)
at org.apache.thrift.transport.TSocket.open(TSocket.java:185)
at
org.apache.hive.jdbc.HiveConnection.openTransport(HiveConnection.java:190)
... 27 more
Caused by: java.net.ConnectException: Connection refused (Connection
refused)
at java.net.PlainSocketImpl.socketConnect(Native Method)
at
java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at
java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at
java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:580)
at org.apache.thrift.transport.TSocket.open(TSocket.java:180)
Thanks,
Abhi
--
Abhi Basu
Re: Impala configs for Zeppelin Interpreter
Posted by Abhi Basu <90...@gmail.com>.
I thought it was the port I had typed in earlier, but get same exception
with 21050.
Thanks,
Abhi
On Fri, Nov 17, 2017 at 10:39 AM, Abhi Basu <90...@gmail.com> wrote:
> Hive works fine but impala does not.
>
> Interpreter setting:
> common.max_count 1000
> default.driver org.apache.hive.jdbc.HiveDriver
> default.password
> default.url jdbc:hive2://hadoop-nn2:10000
> default.user hive
> impala.driver org.apache.hive.jdbc.HiveDriver
> impala.password
> impala.url jdbc:hive2://hadoop-nn2:20150/;auth=noSasl
> impala.user impala
>
> CDH 5.13 cluster - 6 node, Zeppelin 0.73 binaries
>
>
> Logs:
> ERROR, exception: null, result: %text java.sql.SQLException: Could not
> open client transport with JDBC Uri: jdbc:hive2://hadoop-nn2.
> esolocal.com:20150/;auth=noSasl: java.net.ConnectException: Connection
> refused (Connection refused)
> at org.apache.hive.jdbc.HiveConnection.openTransport(
> HiveConnection.java:215)
> at org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:163)
> at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:105)
> at java.sql.DriverManager.getConnection(DriverManager.java:571)
> at java.sql.DriverManager.getConnection(DriverManager.java:187)
> at org.apache.commons.dbcp2.DriverManagerConnectionFactory
> .createConnection(DriverManagerConnectionFactory.java:79)
> at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(
> PoolableConnectionFactory.java:205)
> 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.commons.dbcp2.PoolingDriver.connect(PoolingDriver.java:129)
> at java.sql.DriverManager.getConnection(DriverManager.java:571)
> at java.sql.DriverManager.getConnection(DriverManager.java:233)
> at org.apache.zeppelin.jdbc.JDBCInterpreter.getConnectionFromPool(
> JDBCInterpreter.java:360)
> at org.apache.zeppelin.jdbc.JDBCInterpreter.getConnection(
> JDBCInterpreter.java:378)
> at org.apache.zeppelin.jdbc.JDBCInterpreter.executeSql(
> JDBCInterpreter.java:570)
> at org.apache.zeppelin.jdbc.JDBCInterpreter.interpret(
> JDBCInterpreter.java:709)
> at org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(
> LazyOpenInterpreter.java:97)
> at org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$
> InterpretJob.jobRun(RemoteInterpreterServer.java:498)
> at org.apache.zeppelin.scheduler.Job.run(Job.java:175)
> at org.apache.zeppelin.scheduler.ParallelScheduler$JobRunner.
> run(ParallelScheduler.java:162)
> at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:473)
> at java.util.concurrent.FutureTask.run(FutureTask.java:262)
> 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:1152)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(
> ThreadPoolExecutor.java:622)
> at java.lang.Thread.run(Thread.java:748)
> Caused by: org.apache.thrift.transport.TTransportException:
> java.net.ConnectException: Connection refused (Connection refused)
> at org.apache.thrift.transport.TSocket.open(TSocket.java:185)
> at org.apache.hive.jdbc.HiveConnection.openTransport(
> HiveConnection.java:190)
> ... 27 more
> Caused by: java.net.ConnectException: Connection refused (Connection
> refused)
> at java.net.PlainSocketImpl.socketConnect(Native Method)
> at java.net.AbstractPlainSocketImpl.doConnect(
> AbstractPlainSocketImpl.java:339)
> at java.net.AbstractPlainSocketImpl.connectToAddress(
> AbstractPlainSocketImpl.java:200)
> at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:
> 182)
> at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
> at java.net.Socket.connect(Socket.java:580)
> at org.apache.thrift.transport.TSocket.open(TSocket.java:180)
>
> Thanks,
>
> Abhi
>
> --
> Abhi Basu
>
--
Abhi Basu