Sanbox 2.3.2 hive beeline error

[#1]

Why I got hive internal error?

[mktg1@sandbox ~]$ beeline
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/usr/hdp/2.3.2.0-2950/spark/lib/spark-assembly-1.4.1.2.3.2.0-2950-hadoop2.7.1.2.3.2.0-2950.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/usr/hdp/2.3.2.0-2950/hadoop/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
WARNING: Use "yarn jar" to launch YARN applications.
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/usr/hdp/2.3.2.0-2950/spark/lib/spark-assembly-1.4.1.2.3.2.0-2950-hadoop2.7.1.2.3.2.0-2950.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/usr/hdp/2.3.2.0-2950/hadoop/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
Beeline version 1.2.1.2.3.2.0-2950 by Apache Hive
beeline> !connect jdbc:hive2://localhost:10000
Connecting to jdbc:hive2://localhost:10000
Enter username for jdbc:hive2://localhost:10000: mktg1
Enter password for jdbc:hive2://localhost:10000: ********
Connected to: Apache Hive (version 1.2.1.2.3.2.0-2950)
Driver: Hive JDBC (version 1.2.1.2.3.2.0-2950)
Transaction isolation: TRANSACTION_REPEATABLE_READ
0: jdbc:hive2://localhost:10000> show databases;
Error: Error while processing statement: FAILED: Hive Internal Error: com.sun.jersey.api.client.ClientHandlerException(java.io.IOException: java.net.ConnectException: Connection refused) (state=08S01,code=12)
0: jdbc:hive2://localhost:10000>

[#2]

java.net.ConnectException:Connection refused

This is connection error, it is unclear as why you are getting the error. You may look at hiveserver2 logs. It may have also happened that the hiveserver2 may have tripped.

If it is not obvious take a tcpdump on the traffic and see where it is failing. I hope you do not have to go this far.

[#3]

Try restarting Hive from Ambari. If it still doesn't work, try connecting with --verbose to get more error logging and checking hive server (/var/log/hive/hiveserver2.log) and client logs (/tmp/root/hive.log)

Tried it on mine and it seemed to work fine

# beeline --verbose -u 'jdbc:hive2://localhost:10000' -n mktg1 -p mktg1
WARNING: Use "yarn jar" to launch YARN applications.
issuing: !connect jdbc:hive2://localhost:10000 mktg1 [passwd stripped]
Connecting to jdbc:hive2://localhost:10000
Connected to: Apache Hive (version 1.2.1000.2.4.0.0-169)
Driver: Hive JDBC (version 1.2.1000.2.4.0.0-169)
Transaction isolation: TRANSACTION_REPEATABLE_READ
Beeline version 1.2.1000.2.4.0.0-169 by Apache Hive
0: jdbc:hive2://localhost:10000> show databases;
Getting log thread is interrupted, since query is done!
+----------------+--+
| database_name  |
+----------------+--+
| default        |
| xademo         |
+----------------+--+
2 rows selected (0.206 seconds)

[#4 · Accepted solution]

Thanks. I checked HS2 logs and found it has dependency on atlas now. I did turn Atlas off. Restarting Atlas makes my query running with good results.