https://community.cloudera.com/t5/Support-Questions/Error-while-querying-HIve-tables-from-HUE/m-p/295096#M217591 <P><a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/50045">@bhara</a>&nbsp; The error is very specific "<SPAN>OperationalError: database is locked"</SPAN></P><P>&nbsp;</P><P><SPAN>Have you checked the database.table you are querying is locked or not? &nbsp;&nbsp;<BR />If the error is indeed from the oracle metastore, is that database or table locked?</SPAN></P><P>&nbsp;</P><P>You could test another query on another table as well, to see if it is just that table locked. &nbsp;After removing the lock, does the query work again? &nbsp; Sometimes hive can lock tables, and never unlock them. &nbsp;You would need to query the hive metastore directly, and manually remove these locks if they persist.</P> Wed, 29 Apr 2020 20:08:36 GMT stevenmatison 2020-04-29T20:08:36Z