https://community.cloudera.com/t5/Support-Questions/Unable-to-run-Hive-query-through-putty/m-p/292349#M216041 <P><a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/74173">@ARVINDR</a>&nbsp;</P><P>This is a permission issue in hdfs, so what you should do is as follow to resolve the issue</P><P>Assuming you are logged in as root&nbsp; change recursively the directory owner to [<STRONG>user:group</STRONG> ] <STRONG><FONT color="#FF6600">hive:hdfs</FONT></STRONG></P><LI-CODE lang="markup"># su - hdfs $ hdfs dfs -chown -R hive:hdfs /tmp/hive</LI-CODE><P><U><STRONG>Check the ownership now</STRONG></U></P><LI-CODE lang="markup">$ hdfs dfs -ls /tmp</LI-CODE><P><STRONG><U>Desired output</U></STRONG></P><P>The output should match the&nbsp; below snippet&nbsp;</P><LI-CODE lang="markup">drwxrwxrwx - hive hdfs 0 2018-12-12 23:43 /tmp/hive</LI-CODE><P><BR />Now if you re-run HQL it should succeed.</P><P><BR />Please let me know</P> Mon, 23 Mar 2020 21:38:03 GMT Shelton 2020-03-23T21:38:03Z