query works in Hive 1.x but not in beeline
<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>