如果出现锁表,或者 iceberg 表删除没有删干净,是由于hive 里面有还有元数据导致的,
下面是删除元数据的的操作步骤 ,手动处理
DBS hdfs表位置存储
SDS hdfs表库表位置存储
TBLS 库表名 存储
CDS 表id 存储
TABLE_PARAMS 表属性存储
COLUMNS_V2 表字段存储
SERDES 表的format存储
sd_id=26573171 SDS TBLS
cd_id=13166129 SDS
db_id = 1021 TBLS
tbl_id = 12625433 TBLS
serde_id = 26573161 SDS
-- 注意表的顺序
DELETE FROM TABLE_PARAMS WHERE tbl_id = 12625433; -- 1
DELETE FROM SD_PARAMS WHERE sd_id = 26573171; -- 2
DELETE FROM COLUMNS_V2 WHERE cd_id =13166129; -- 3
DELETE FROM TBLS WHERE tbl_id = 12625433; -- 4
DELETE FROM SDS WHERE sd_id = 26573171; -- 5
DELETE FROM SERDES WHERE serde_id =26573161; -- 6
DELETE FROM CDS WHERE cd_id =13166129; -- 7