insert into 语句报错:

报错

This command is not allowed on an ACID table tb1 with a non-ACID transaction manager. Failed command.

解决方法

命令行输入:

set hive.auto.convert.join.noconditionaltask.size = 10000000; 
set hive.support.concurrency = true; 
set hive.enforce.bucketing = true; 
set hive.exec.dynamic.partition.mode = nonstrict; 
set hive.txn.manager = org.apache.hadoop.hive.ql.lockmgr.DbTxnManager; 
set hive.compactor.initiator.on = true;

命令行的意思就是让hive支持update delete.