Yes correct On Jan 22, 2018 11:44 PM, "Jeff Zhang" <zjf...@gmail.com> wrote:
> > Just curious to know does impala use HiveDriver ? > > Abhi Basu <9000r...@gmail.com>于2018年1月23日周二 上午12:50写道： > >> 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 >> >
