hive删除表后重新创建时提示表已存在并且卡死

SQL 错误 [1] [08S01]: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. org.apache.iceberg.exceptions.AlreadyExistsException: Table was created concurrently: iceberg_dw.dw_xxxxxxxx

iceberg表在写入时,会在hive的元数据表hive_locks中增加一行该表的锁记录,当不正常退出时,就会导致删除或者创建就表时出现此问题。
手工去hive_locks 表删除该表对应的记录即可。

delete from HIVE_LOCKS where hl_db = 'iceberg_dw' and hl_table = 'dw_xxxxxxxx';

版权声明:本文为wang6733284原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。