hive server2 interactive logs

[#1]

Hi

Our Hive Server2 Interactive is stopping after around 10 min after restart.

I couldn't find hiveserver2Interactive.log in /var/log/hive, hive-server2-interactive.err is showing following:

/usr/hdp/current/hive-server2/conf_llap//hive-env.sh: line 43: [: !=: unary operator expected

2018-11-07 14:40:33: Starting HiveServer2 
SLF4J: Class path contains multiple SLF4J bindings. 
SLF4J: Found binding in [jar:file:/usr/hdp/3.0.1.0-187/hive/lib/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class] 
SLF4J: Found binding in [jar:file:/usr/hdp/3.0.1.0-187/hadoop/lib/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] 

Hive Session ID = c4e8edc5-ed5e-4f96-ba70-00779ac20dc9 
Hive Session ID = b5ad883d-4a65-45f7-a6dd-1ea3797724ea

Any help will be appreciated.

Thanks

[#2 · Accepted solution]

@Mujeeb

This error is due to a bug: "/usr/hdp/current/hive-server2/conf_llap//hive-env.sh: line 43: [: !=: unary operator expected"

Please refer: https://community.hortonworks.com/content/supportkb/225891/errorusrhdp3000-1634hiveconfhive-envsh-li... (looks like line numbers are different in article and the error you have, update accordingly)

Hope this helps.

[#3]

Many Thanks Sandeep.

Yes it is working now. I would like to add more details for fix:

Update hive-interactive-env template and hive-env template Hive config properties from Ambari UI.