https://community.cloudera.com/t5/Support-Questions/Reading-a-Hive-table-while-doing-insert-overwrite-on-a/m-p/220362#M182247 <A rel="user" href="https://community.cloudera.com/users/16119/viswanathkammula.html" nodeid="16119">@viswanath </A><P>When you are running the insert statement for a static partition then the lock is obtained over the folder which would be created for the static partition. Now your select query would running over the entire table or the entire folder created for the table which includes all the partition including the one which you are overwriting. In such case it comes to simple file handling. When a file is getting written then it locks the file. The same applies here as well. Hope it helps!!</P> Sat, 14 Oct 2017 17:10:42 GMT balavignesh_nag 2017-10-14T17:10:42Z