HIVE删除分区表drop table tbl_name
时
报错:
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:Invalid partition key & values; keys [year, month, day, hour, ], values [2018, ])
错误原因:对应的key不匹配
解决方案:
1、删除对应分区
alter table tbl_name drop partition(year=2018)
2、删除表
drop table tbl_name
OK