记录hive删除元数据报错

hdfs上文件没有了，但是元数据表还在，删除和查询会报错

FAILED: SemanticException Unable to fetch table. null

 解决办法：

select tbl_id from TBLS where TBL_NAME='tmp_cdt_cdt_canal_test_text_h' and DB_ID=(select DB_ID from (select DB_ID from DBS where NAME='ld_tmp_bak')step_1);
select DB_ID from (select DB_ID from DBS where NAME='ld_tmp_bak')step_1;
delete from PARTITION_KEY_VALS WHERE PART_ID in (select PART_ID from PARTITIONS where TBL_ID=513);
delete from PARTITION_PARAMS WHERE PART_ID in (select PART_ID from PARTITIONS where TBL_ID=513); 
delete from PARTITIONS where TBL_ID=513; 
delete from TBL_COL_PRIVS where TBL_ID=513;
delete from TBL_PRIVS where TBL_ID=513; 
delete from TBLS where TBL_ID=513; 

报错信息 Cannot delete or update a parent row 

关闭外键约束

SET FOREIGN_KEY_CHECKS=0;