报错信息:metaException(message:java.lang.NullPointerException)
-
原因:hive 表存储在mysql 中的元数据出现异常了
-
解决:
外部表:删除mysql 中表元数据,表重建。
内部表:删除mysql 中元数据,表重建且重新导入数据。外部表 sql 操作语句:
use hive 库;
1. 查询出 表 id
select * from TBLS where TBL_NAME =‘ads_fmc_idx_batch_pig_sales_survival_rate’2. 根据表id 删除元数据: delete from TAB_COL_STATS where TBL_ID = 696345; delete from TABLE_PARAMS where tbl_id = 696345; delete from TBLS where TBL_NAME ='ads_fmc_idx_batch_pig_sales_survival_rate';



