Hive Server 2 failing to start CDP ,Cloudera Manager 7

[#1]

Hi All

My Hive Server 2 is failing to start,Below is the complete log file of the failure,i am unable to figure out whats causing the failure of the service.

2020-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!
	at org.apache.hadoop.hive.conf.HiveConf.validateExecutionEngine(HiveConf.java:5594)
	at org.apache.hadoop.hive.conf.HiveConf.initialize(HiveConf.java:5578)
	at org.apache.hadoop.hive.conf.HiveConf.<init>(HiveConf.java:5434)
	at org.apache.hadoop.hive.common.LogUtils.initHiveLog4jCommon(LogUtils.java:100)
	at org.apache.hadoop.hive.common.LogUtils.initHiveLog4j(LogUtils.java:84)
	at org.apache.hive.service.server.HiveServer2.main(HiveServer2.java:1130)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.apache.hadoop.util.RunJar.run(RunJar.java:318)
	at org.apache.hadoop.util.RunJar.main(RunJar.java:232)

 

[#2]

Hello @SwasBigData ,

thank you for raising the question about why HiveServer2 is failing to start in CDP.

This issue occurs because HiveServer2 has been moved outside of Hive Service in CDP.

To resolve this issue, simply remove HiveServer2 from Hive Service and install Hive on Tez service. Tez is the only engine that is supported in Hive in CDP environment.

Please let us know if we answered the enquiry by accepting the answer as a solution.

Best regards:

Ferenc

[#3]

Thanks Ferenc

I did found that out and tried to setup Tez but ended up having much errors,there isn't any specific documentation that guides me how i need to set up Tez for Hive in  CM 7+.

Any details would be helpful

[#4]

Hello @SwasBigData , just would like to check with you if you tried the below:

remove HiveServer2 then install Hive service first (without choosing HS2), and then install Hive on Tez. Did it work?

Thank you for pointing out the lack of documentation. Following up this internally.

Kind regards:
Ferenc

[#5 · Accepted solution]

Hi @SwasBigData ,

As Ferenc pointed out, In CDP, HiveServer2 and HiveMetaStore are separated into different services. The Hive Service now only contains HMS, and HiveServer2 is included in the Hive on Tez service.

So to install Hive on Tez, you have to install Hive Service first, which will setup HMS.

Can you please share more details on what error you got when trying to setup Hive on Tez?

Thanks
Eric