主题:hive插入数据
因为数据消费异常,需要在hive桶表中插入历史分区数据,一开始的SQL:
insert overwrite table 桶表 partition(partition='2020-10-30')
select * from 分区表 t where t.partition='2020-10-30'
报错:
org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: SemanticException [Error 10295]: INSERT OVERWRITE not allowed on table with OutputFormat that implements AcidOutputFormat while transaction manager that supports ACID is in use
at org.apache.hive.jdbc.Utils.verifySuccess(Utils.ja