https://community.cloudera.com/t5/Support-Questions/what-is-the-default-behavior-of-insert-overwrite-on-external/m-p/236537#M198350 <P>Hi <A rel="user" href="https://community.cloudera.com/users/99447/dahailong.html" nodeid="99447">@dahai long</A>;</P><P>Have you tried using:</P><PRE>hdfs dfs -chown -R &lt;your_user&gt;:&lt;your_group&gt; /&lt;related path&gt;</PRE><P>i.e.</P><PRE>[hdfs@c3253-node3 ~]$ hdfs dfs -chown -R hive:hive /data1</PRE><P> I tried without the -R and could not create the directory automatically, but once changed the owner and also added the -R, did not have any issue, could you please try that and let me know the results.</P><P>Regards,</P><P>Ariel Q.</P> Thu, 22 Nov 2018 03:25:54 GMT aquilodran 2018-11-22T03:25:54Z