HIVE Error : Connection refused

[VIVEK NARAYANASETTY <vi...@gmail.com>]

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.*

RE: HIVE Error : Connection refused

[Vivek Narayanasetty <vi...@gmail.com>]

Port is not up and running. Here are the results to check if port is running
or not.

C:\Users\viveknarayanasetty>netstat -an | find "10000"

C:\Users\viveknarayanasetty>

I am completely new to zeppelin and trying to configure hive interpreter.
Could you please let me know if I need to perform any additional steps.



--
View this message in context: http://apache-zeppelin-users-incubating-mailing-list.75479.x6.nabble.com/HIVE-Error-Connection-refused-tp3692p3700.html
Sent from the Apache Zeppelin Users (incubating) mailing list mailing list archive at Nabble.com.

RE: HIVE Error : Connection refused

[Joaquin Alzola <Jo...@lebara.com>]

>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

Check that you port 10000 is up an running. (netstat –anp | grep 10000)

Be aware on the name localhost depending where you are launching your Zeppelin.

This email is confidential and may be subject to privilege. If you are not the intended recipient, please do not copy or disclose its content but contact the sender immediately upon receipt.