<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>question Re: Unable to run Hive query through putty in Support Questions</title>
    <link>https://community.cloudera.com/t5/Support-Questions/Unable-to-run-Hive-query-through-putty/m-p/292373#M216061</link>
    <description>&lt;P&gt;Hi&amp;nbsp;&lt;a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/20288"&gt;@Shelton&lt;/a&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I changed the permissions as advised.&lt;/P&gt;&lt;P&gt;However, getting the same error.&lt;/P&gt;&lt;P&gt;The new folder inside _tez_session_dir gets created with root ownership instead of &amp;lt;hive_user&amp;gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Pls note that &amp;lt;hive_user&amp;gt; has been mapped to root at Isilon side.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I tried creating another user hdpuser1 using below commands in mysql after login as root&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;create user 'hdpuser1'@'%'&amp;nbsp; identified by 'xxxxx';&lt;BR /&gt;grant all on hive.* TO 'hdpuser1'@'%' IDENTIFIED BY 'xxxxx';&lt;/P&gt;&lt;P&gt;FLUSH PRIVILEGES;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;However, this doesn't work.&lt;/P&gt;&lt;P&gt;20/03/24 02:24:55 [main]: WARN jdbc.HiveConnection: Failed to connect to &amp;lt;FQDN of Data Node&amp;gt;:10000&lt;/P&gt;&lt;P&gt;20/03/24 02:24:55 [main]: ERROR jdbc.Utils: Unable to read HiveServer2 configs from ZooKeeper​&lt;/P&gt;&lt;P&gt;Error: Could not open client transport for any of the Server URI's in ZooKeeper: Failed to open new session: java.lang.RuntimeException: org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.authorize.AuthorizationException): Username: 'hdpuser1' not found. Make sure your client's username exists on the cluster (state=08S01,code=0)​&lt;/P&gt;&lt;P&gt;Beeline version 3.1.0.3.0.1.0-187 by Apache Hive​&lt;/P&gt;&lt;P&gt;beeline&amp;gt;​&lt;/P&gt;</description>
    <pubDate>Tue, 24 Mar 2020 07:28:59 GMT</pubDate>
    <dc:creator>ARVINDR</dc:creator>
    <dc:date>2020-03-24T07:28:59Z</dc:date>
  </channel>
</rss>

