hive Error SemanticException Unable to fetch table

一、背景

无

二、现象

在hive中对某个表执行任何操作，都会报错：

hive Error SemanticException Unable to fetch table
1

而同库内其他表，其他库的表，均可以正常查询。

三、问题排查过程

无

四、原因分析

hive的mysql元数据表内存在脏数据导致

五、解决

1. select DB_ID from DBS where NAME='your-database-name'
2. select tbl_id from TBLS where TBL_NAME='your-table-name' and DB_ID=<id from step 1>;
3. delete from PARTITION_KEY_VALS WHERE PART_ID in (select PART_ID from PARTITIONS where TBL_ID=<id from step 2>);
4. delete from PARTITION_PARAMS WHERE PART_ID in (select PART_ID from PARTITIONS where TBL_ID=<id from step 2>); 
5. delete from PARTITIONS where TBL_ID=<id from step 2>; 
6. delete from TBL_COL_PRIVS where TBL_ID=<id from step 2>;
7. delete from TBL_PRIVS where TBL_ID=<id from step 2>; 
8. delete from TBLS where TBL_ID=<id from step 2>; 
9. COMMIT; 
1
2
3
4
5
6
7
8
9

六、反思与规避

问题发生的原因还没找到。

好记性不如赖笔头。
与君共勉。
1
2