https://community.cloudera.com/t5/Support-Questions/How-to-identify-the-user-who-has-acquired-table-lock-in-Hive/m-p/226749#M188609 <P>@<A href="https://community.hortonworks.com/users/15532/skumarsandeep85.html">Sandeep SIngh</A></P><P>No, hive doesn't maintain any lock history.</P><PRE>show locks;</PRE><P>Above command would help you to get the user who has acquired a lock over the table in hive. But however if the lock is released then you will not be able to see the user who has acquired the locks. Also there is no history of locks being recorded as it is not necessarily needed for the namenode for any computation.</P><P>Hope it helps! </P> Wed, 20 Dec 2017 17:44:14 GMT balavignesh_nag 2017-12-20T17:44:14Z