Hive drop table not working - Hanging

Question

I tried dropping a HIVE table. Screen hangs. I tried in both HIVE CLI and beeline. Neither the table getting dropped nor the data getting inserted into the table. Need help!

Answer 1

Actually the table was locked with some queries. After unlocking the table, I am able to drop the table now.

=>Query to unlock the table

unlock table <tablename>

=>We can find the tables which are locked in the Hive CLI /Beeline:

show locks extended;

Answer 2

I had simular issue but I was not able even to drop hive database which had this table inside.

I had to manually delete from metastoredb coruppted record.

Before do that of course do mysqldump just in case :)

In table TBLS record which was coresponding to the table. Record atributes SD_ID, VIEW_EXPANDED_TEXT,VIEW_ORIGINAL_TEXT were null.

To find it:

SELECT DB.DB_ID,
       DB.NAME AS DB_NAME,
       TB.SD_ID,
       TB.TBL_ID,
       TB.TBL_NAME,
       SD.SD_ID,
       SD.INPUT_FORMAT,
       CD.*
FROM TBLS AS TB
     left JOIN DBS AS DB ON(DB.DB_ID = TB.DB_ID)
     left JOIN SDS AS SD ON(TB.SD_ID = SD.SD_ID)
     left JOIN COLUMNS_V2 AS CD ON(SD.CD_ID = CD.CD_ID)
WHERE 
TB.TBL_NAME='your_name';

Then I had to delete all FK of this record inside two other tables:

 delete from TBL_COL_PRIVS where TBL_ID=xxxx ;
 delete from TBL_PRIVS where TBL_ID=xxxx ;
 delete from TBLS where TBL_ID=xxxx ;