hive Unable to fetch table/MetaException(message:java.lang.NullPointerException)

@[TOC](hive Unable to fetch table/MetaException(message:java.lang.NullPointerException))

现象：无法 操作表
原因可能如下：
1、hive 元数据有异常 （常见是此种情况）

解决方法：

1、查询对应库下的表
select TBL_ID from yz_dev_hive.TBLS  where TBL_NAME ='dwd_fpf_anc_file_info' and DB_ID = (select DB_ID from dbs where NAME = 'yz_dw_dwd');
2. 根据表id 删除元数据：
delete from yz_dev_hive.TAB_COL_STATS where TBL_ID in (1793110);
delete  from yz_dev_hive.table_params where TBL_ID in (1793110);
delete from yz_dev_hive.tbl_col_privs where TBL_ID in (1793110) ;
delete from yz_dev_hive.tbl_privs where TBL_ID in (1793110);
delete from yz_dev_hive.TBLS  where TBL_ID = 1793110 and DB_ID = (select DB_ID from dbs where NAME = 'yz_dw_dwd');

2、hive 表被锁
解决方法：解锁表，并关闭 hive 锁机制