Take MySQL backup before doing this operation. Go to MySQL use <DB>; select * from TBLS where tbl_name = '<table_name>'; Make a note of TBL_ID from the table and delete entries from TABLE_PARAMS , TBL_COL_PRIVS , TBL_PRIVS using where clause TBL_ID After getting this done, try the below command. delete from TBLS where tbl_name = '<table_name>'; Now open hive shell and check for the table. ... View more