Hive Server 2 Error Cloudera Manager 7.0 -CDP

[#1]

Hi All

In my CDP environment,  Hive Server 2 is failing to start,Below is the log for the same

0-03-25 08:33:56: Starting HiveServer2
WARNING: Use "yarn jar" to launch YARN applications.
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/opt/cloudera/parcels/CDH-7.0.3-1.cdh7.0.3.p0.1635019/jars/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/opt/cloudera/parcels/CDH-7.0.3-1.cdh7.0.3.p0.1635019/jars/slf4j-log4j12-1.7.25.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.apache.logging.slf4j.Log4jLoggerFactory]
Exception in thread "main" java.lang.IllegalArgumentException: mr execution engine is not supported!

of the failure,i am unable to figure out whats causing the failure of the service.

[#2 · Accepted solution]

I Further checked as per the Cloudera Manager Error Advice Instructions

to run the below command,however i don't seem to have the agent present and running,what is that i am missing?

[User_XXX@cdh-mgr ~]$ /etc/init.d/cloudera-scm-agent status
-bash: /etc/init.d/cloudera-scm-agent: No such file or directory

[#3 · Accepted solution]

This is now solved.

Seems like Hive execution as MR isn't supported in Hive Server 2 anymore,i changed it to Spark and restarted the server,it worked.

[#4 · Accepted solution]

I Further checked as per the Cloudera Manager Error Advice Instructions

to run the below command,however i don't seem to have the agent present and running,what is that i am missing?

[User_XXX@cdh-mgr ~]$ /etc/init.d/cloudera-scm-agent status
-bash: /etc/init.d/cloudera-scm-agent: No such file or directory

[#5 · Accepted solution]

This is now solved.

Seems like Hive execution as MR isn't supported in Hive Server 2 anymore,i changed it to Spark and restarted the server,it worked.

[#6]

how did you change MR to spark can you please share the steps . I'm also facing the same issue .

[#7 · Accepted solution]

Hi

Although i managed to get that changed however it seems like it is not supported,see my other thread around the errors i faced,where Hive on Tez is only recommended.

But to answer your question we can change this on Hive Configurations.

Go to CM->Hive-> Configurations->search on execution engine-> change the parameter to Spark from MR.(Default would have been MR.It will get rid of the errors and your services will start all green but you still have runtime failures.

https://community.cloudera.com/t5/Support-Questions/Hive-on-Spark-Cloudera-Manager-7-03-Unable-to-Pr...