title: Hive alter location statement not working
body: <pre><code>hive&gt; alter table my_table_name set location "hdfs://nameservice1/foo";
  OK
  Time taken: 0.173 seconds
  hive&gt; alter table my_table_name set location "hdfs://nameservice1/foo/bar";
  Authorization failed:org.apache.hadoop.security.AccessControlException: action WRITE not permitted on path hdfs://nameservice1/foo for user hadoop_user. Use show grant to get more details.
  </code></pre>
  
  <p>As seen in the above screen output, the alter table location is working exactly once on the external table and subsequently it is throwing an error. 
  Please advice how I could get the alter table location statement to work.</p>