title: query works in Hive 1.x but not in beeline
body: <p>With Hive 1.x, my query similar to this:</p>
  
  <pre><code>select ... from Table group by column;
  </code></pre>
  
  <p>works fine.  However with beeline like so</p>
  
  <pre><code>alias beeline='beeline -u jdbc:hive2://localhost:10000 -u hadoop -p pass --hiveconf  hive.resultset.use.unique.column.names=false --hiveconf  hive.groupby.orderby.position.alias=true'
  </code></pre>
  
  <p>which uses </p>
  
  <pre><code>$HIVE_HOME/bin/hive --service hiveserver2
  </code></pre>
  
  <p>which is ran by the user hadoop causes:</p>
  
  <p><em>Caused by: org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.AccessControlException): Permission denied: user=anonymous, access=EXECUTE, inode="/tmp/hadoop-yarn":hadoop:supergroup:drwx------</em></p>
  
  <p>I also got a similar error in beeline vs hive directly with another query:</p>
  
  <p><em>Error: Error while compiling statement: FAILED: SemanticException 0:0 Error creating temporary folder on: hdfs://localhost:9000/user/hive/warehouse. Error encountered near token 'TOK_TMP_FILE' (state=42000,code=40000)</em></p>
  
  <p>Trying this in my hive-site.xml:</p>
  
  <pre><code> &lt;property&gt;
     &lt;name&gt;hive.server2.enable.doAs&lt;/name&gt;
     &lt;value&gt;true&lt;/value&gt;
   &lt;/property&gt;
  </code></pre>
  
  <p>did not work...</p>
  
  <p>Ideas?</p>