Seems like a 0.7.3 bug, please verify. The same configurations worked fine in 0.7.2.
Thanks, Abhi On Mon, Jan 22, 2018 at 10:04 AM, Abhi Basu <9000r...@gmail.com> wrote: > Need some help. Not sure why the connection is failing. Using Zeppelin > 0.7.3 binary with CDH 5.13. > > Hive confg file copied to Z/conf folder and other configs done in zeppelin > config files. > > > Config: > > > Properties > namevalue > common.max_count 1000 > default.driver org.apache.hive.jdbc.HiveDriver > default.password > default.url jdbc:hive2://hadoop-nn4.eso.local:10000 > default.user hive > impala.driver org.apache.hive.jdbc.HiveDriver > impala.password > impala.url jdbc:hive2://hadoop-dn4.eso.local:20150/;auth=noSasl > impala.user impala > zeppelin.interpreter.localRepo /usr/local/bin/zeppelin-073/ > local-repo/2D5A9CHGW > zeppelin.interpreter.output.limit 102400 > zeppelin.jdbc.auth.type > zeppelin.jdbc.concurrent.max_connection 10 > zeppelin.jdbc.concurrent.use true > zeppelin.jdbc.keytab.location > zeppelin.jdbc.principal > > > Logs: > java.sql.SQLException: Could not open client transport with JDBC Uri: > jdbc:hive2://hadoop-dn4.eso.local: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) > > -- > Abhi Basu > -- Abhi Basu
