Unable to connect to Hive CLI

[#1]

Issue:

User has a valid kerberos ticket, when he's trying to connect to Hive CLI - the session throws the below error

[karthick@mrt1 ~]$ hive 
WARNING: Use "yarn jar" to launch YARN applications. 

Logging initialized using configuration in file:/etc/hive/2.4.3.0-227/0/hive-log4j.properties Exception in thread "main" java.lang.RuntimeException: org.apache.tez.dag.api.SessionNotRunning: TezSession has already shutdown. No cluster diagnostics found. at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:544) 
at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:680) 
at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:624) 
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:221) 
at org.apache.hadoop.util.RunJar.main(RunJar.java:136) 
Caused by: org.apache.tez.dag.api.SessionNotRunning: TezSession has already shutdown. No cluster diagnostics found. 
at org.apache.tez.client.TezClient.waitTillReady(TezClient.java:731) 
at org.apache.hadoop.hive.ql.exec.tez.TezSessionState.open(TezSessionState.java:217) 
at org.apache.hadoop.hive.ql.exec.tez.TezSessionState.open(TezSessionState.java:117) 
at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:541) 

Resolution:

Customer to open ports between the client and the datanodes as Tez is unable to launch AM. Also, request customer to set the below configs

tez.am.client.am.port-range (32000-65000) yarn.app.mapreduce.am.job.client.port-range (32000-65000) tez.app.mapreduce.am.job.client.port-range (32000-65000) Also on Redhat/CentOS, ephemeral port range can be configured via: /etc/sysctl.conf # Allowed local port range

net.ipv4.ip_local_port_range = 32768 61000