刪除分區失敗：
alter table proj_60_finance.dwd_fm_ma_kpi_di_mm drop partition(year=2025,month=0-3,type=ADJ);

1、查詢分區的DB_ID、TBL_ID
– 獲取數據庫ID-26110
SELECT DB_ID FROM DBS WHERE NAME = ‘proj_60_finance’;
– 獲取表ID-307194
SELECT TBL_ID FROM TBLS WHERE TBL_NAME = ‘dwd_fm_ma_kpi_di_mm’ AND DB_ID = 26110;

2、 查詢分區的PART_ID和SD_ID
– 根據分區鍵值查找PART_ID
–第一個分區鍵year的值
–第二個分區鍵month的值
–第三個分區鍵type的值
SELECT p., pk1., pk2., pk3.
FROM PARTITIONS p
JOIN PARTITION_KEY_VALS pk1 ON p.PART_ID = pk1.PART_ID
JOIN PARTITION_KEY_VALS pk2 ON p.PART_ID = pk2.PART_ID
JOIN PARTITION_KEY_VALS pk3 ON p.PART_ID = pk3.PART_ID
WHERE p.TBL_ID = 307194
AND pk1.INTEGER_IDX = 0 AND pk1.PART_KEY_VAL = ‘2025’
AND pk2.INTEGER_IDX = 1 AND pk2.PART_KEY_VAL = ‘0-3’
AND pk3.INTEGER_IDX = 2 AND pk3.PART_KEY_VAL = ‘ADJ’;

3、 刪除相關元數據
– 刪除分區鍵值（PARTITION_KEY_VALS）
select * FROM PARTITION_KEY_VALS WHERE PART_ID = 18620706;
DELETE FROM PARTITION_KEY_VALS WHERE PART_ID = 18620706;
– 刪除分區參數（PARTITION_PARAMS，如果有）
select * FROM PARTITION_PARAMS WHERE PART_ID = 18620706;
DELETE FROM PARTITION_PARAMS WHERE PART_ID = 18620706;
– 刪除分區記錄（PARTITIONS）
select * FROM PARTITIONS WHERE PART_ID = 18620706;
DELETE FROM PARTITIONS WHERE PART_ID = 18620706;
– 刪除存儲描述（SDS，確保無其他引用）
select * FROM SDS WHERE SD_ID = 23951880;
DELETE FROM SDS WHERE SD_ID = 23951880;
– 可選：刪除統計信息（PART_COL_STATS）
select * FROM PART_COL_STATS WHERE PART_ID = 18620706;
DELETE FROM PART_COL_STATS WHERE PART_ID = 18620706;

4、 手動清理HDFS數據
hadoop fs -rm -r /hive/path/to/partition # 替換為實際路徑

5、刷新hive元緩存
msck repair table proj_60_finance.dwd_fm_ma_kpi_di_mm