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 <9000r...@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
