Member since
03-30-2017
3
Posts
0
Kudos Received
0
Solutions
03-31-2017
03:03 AM
Hi Eric Yes I am able to connect to HS2. Moreover, most of my queries are dealing with huge data so the execution time is also high. Most of the days it fails in on or the other hive actions. Also, other jobs including hive action are working fine.
... View more
03-30-2017
09:47 PM
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/opt/cloudera/parcels/CDH-5.9.1-1.cdh5.9.1.p0.4/jars/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/data/11/yarn/nm/filecache/4718/slf4j-log4j12-1.7.5.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]
Connecting to xxx/
Connected to: Apache Hive (version 1.1.0-cdh5.9.1)
Driver: Hive JDBC (version 1.1.0-cdh5.9.1)
Transaction isolation: TRANSACTION_REPEATABLE_READ
No rows affected (0.479 seconds)
No rows affected (0.003 seconds)
No rows affected (0.003 seconds)
No rows affected (0.003 seconds)
No rows affected (0.003 seconds)
No rows affected (0.002 seconds)
No rows affected (0.003 seconds)
HS2 may be unavailable, check server status
Error: org.apache.thrift.transport.TTransportException: java.net.SocketException: Broken pipe (state=08S01,code=0)
Closing: 0: xxx/
HS2 may be unavailable, check server status
Error: Error while cleaning up the server resources (state=,code=0)
Intercepting System.exit(2)
Failing Oozie Launcher, Main class [org.apache.oozie.action.hadoop.Hive2Main], exit code [2]
I have series of hive actions in a oozie workflow and I am getting the same error everyday in or the other hive actions. I have attached the logs of the job which failed. Please help me resolve it.
Running it on CDH 5.9.1 . Have set following global parameters in workflow.xml as well :
hive_server2_session_check_interval=3600000 hive_server2_idle_operation_timeout=86400000 hive_server2_idle_session_timeout=259200000
... View more
Labels:
- Labels:
-
Apache Hive
-
Apache Oozie
-
Apache YARN