https://community.cloudera.com/t5/Support-Questions/Unable-to-run-Hive-query-through-putty/m-p/292420#M216083 <P><a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/74173">@ARVINDR</a>&nbsp;</P><P>In addition to&nbsp;@<A href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/60150" target="_blank" rel="noopener"><SPAN class="">stevenmatison</SPAN></A><SPAN class="">&nbsp; &nbsp; &nbsp;switch command which people usually ignore&nbsp;</SPAN></P><P><STRONG>Add a Hive proxy</STRONG><BR />To prevent network connection or notification problems, you must add a hive user proxy for HiveServer Interactive service to access the Hive Metastore</P><P>&nbsp;</P><P><STRONG>Steps:</STRONG></P><P>In Ambari, <STRONG>select Services &gt; HDFS &gt; Configs &gt; Advanced.</STRONG><BR />In Custom core-site, add the FQDNs of the HiveServer Interactive host or hosts to the value of hadoop.proxyuser.hive.hosts.<BR />Save the changes.</P><P>Can you also set the <STRONG>hive.server2.enable.doAs</STRONG></P><P><STRONG>hive.server2.enable.doAs=true</STRONG> --&gt; Run hive scripts as end user instead of Hive user.</P><P><STRONG>hive.server2.enable.doAs=false</STRONG> --&gt; All the jobs will run as hive user.</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 24 Mar 2020 13:51:17 GMT Shelton 2020-03-24T13:51:17Z