Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Sanbox 2.3.2 hive beeline error

Solved Go to solution

Sanbox 2.3.2 hive beeline error

Contributor

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>
1 ACCEPTED SOLUTION

Accepted Solutions

Re: Sanbox 2.3.2 hive beeline error

Contributor

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.

3 REPLIES 3

Re: Sanbox 2.3.2 hive beeline error

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.

Re: Sanbox 2.3.2 hive beeline error

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)


Re: Sanbox 2.3.2 hive beeline error

Contributor

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.

Don't have an account?
Coming from Hortonworks? Activate your account here