Hive增加Update、Delete支持

• 配制hive-site.xml

<property>
    <name>hive.support.concurrency</name>
    <value>true</value>
</property>
<property>
    <name>hive.exec.dynamic.partition.mode</name>
    <value>nonstrict</value>
</property>
<property>
    <name>hive.txn.manager</name>
    <value>org.apache.hadoop.hive.ql.lockmgr.DbTxnManager</value>
</property>
<property>
    <name>hive.compactor.initiator.on</name>
    <value>true</value>
</property>
<property>
    <name>hive.compactor.worker.threads</name>
    <value>1</value>
</property>

• 完整hive-site.xml

https://download.csdn.net/download/qq_43024380/15041691

• 创建表t2、插入数据、删除t2表中的数据

CREATE TABLE t2 (id INT, name STRING)  CLUSTERED BY (id) INTO 8 BUCKETS STORED AS ORC TBLPROPERTIES ('transactional'='true');
insert into t2 (id,name) values (1,"test");
delete from t2 where id = 1;

• PS:

Attempt to do update or delete on table fps.person that does not use an AcidOutputFormat or is not bucketed