Hi All,
I am getting connection refused error when trying to execute %jdbc(hive) in
zeppelin. Can anyone help on this.
Full StackTrace:
--------------------------
INFO [2016-07-29 17:38:07,318] ({pool-2-thread-2}
JDBCInterpreter.java[interpret]:385) - Run SQL command '(hive)'
INFO [2016-07-29 17:38:07,319] ({pool-2-thread-2}
JDBCInterpreter.java[interpret]:394) - PropertyKey: hive, SQL command: ''
INFO [2016-07-29 17:38:07,319] ({pool-2-thread-2}
JDBCInterpreter.java[getConnection]:219) - org.apache.hive.jdbc.HiveDriver
INFO [2016-07-29 17:38:07,322] ({pool-2-thread-2}
Utils.java[parseURL]:285) - Supplied authorities: localhost:10000
INFO [2016-07-29 17:38:07,323] ({pool-2-thread-2}
Utils.java[parseURL]:372) - Resolved authority: localhost:10000
INFO [2016-07-29 17:38:07,324] ({pool-2-thread-2}
HiveConnection.java[openTransport]:189) - Will try to open client transport
with JDBC Uri: jdbc:hive2://localhost:10000
INFO [2016-07-29 17:38:08,335] ({pool-2-thread-2}
HiveConnection.java[openTransport]:194) - Could not open client transport
with JDBC Uri: jdbc:hive2://localhost:10000
*ERROR [2016-07-29 17:38:08,335] ({pool-2-thread-2}
JDBCInterpreter.java[executeSql]:366) - Cannot run *
*java.sql.SQLException: Could not open client transport with JDBC Uri:
jdbc:hive2://localhost:10000: java.net.ConnectException: Connection
refused: connect*
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.zeppelin.jdbc.JDBCInterpreter.getConnection(JDBCInterpreter.java:222)
at
org.apache.zeppelin.jdbc.JDBCInterpreter.getStatement(JDBCInterpreter.java:233)
at
org.apache.zeppelin.jdbc.JDBCInterpreter.executeSql(JDBCInterpreter.java:292)
at
org.apache.zeppelin.jdbc.JDBCInterpreter.interpret(JDBCInterpreter.java:396)
at
org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:94)
at
org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:341)
at org.apache.zeppelin.scheduler.Job.run(Job.java:176)
at
org.apache.zeppelin.scheduler.ParallelScheduler$JobRunner.run(ParallelScheduler.java:162)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
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:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.apache.thrift.transport.TTransportException:
java.net.ConnectException: Connection refused: connect
at org.apache.thrift.transport.TSocket.open(TSocket.java:185)
at org.apache.thrift.transport.TSaslTransport.open(TSaslTransport.java:248)
at
org.apache.thrift.transport.TSaslClientTransport.open(TSaslClientTransport.java:37)
at
org.apache.hive.jdbc.HiveConnection.openTransport(HiveConnection.java:190)
... 19 more
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.DualStackPlainSocketImpl.connect0(Native Method)
at
java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79)
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.PlainSocketImpl.connect(PlainSocketImpl.java:172)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:579)
at org.apache.thrift.transport.TSocket.open(TSocket.java:180)
... 22 more
--
Thanks & Regards
*Vivek Narayanasetty*
+91 9902862499
*Go Green: Think before you print this e-mail or its attachment. You can
save paper if you do not really need to print.*
