CDH-hive支持insert、update、delete操作

开发要求hive支持update操作，搞张临时表测试下，报错如下：

配置hive-site.xml

CDH进入hive配置页，选择高级，找到hive-site.xml的HIve客户端高级配置段代码段，点击+号，增加如下配置项：

hive.support.concurrency = true
hive.enforce.bucketing = true
hive.exec.dynamic.partition.mode = nonstrict
hive.compactor.initiator.on = true
hive.compactor.worker.threads = 1
hive.txn.manager = org.apache.hadoop.hive.ql.lockmgr.DbTxnManager

点击保存更改，分发配置即可

目前只有ORCFileformat支持AcidOutputFormat，不仅如此建表时必须指定参数('transactional' = true)

于是按照网上示例建表：

hive>create table test(id int ,name string )clustered by (id) into 2 buckets stored as orc TBLPROPERTIES('transactional'='true');

insert

hive>insert into table test values (1,'row1'),(2,'row2'),(3,'row3');

delete

hive>delete from test where id = 1;

update

hive>update test set name = 'Raj' where id = 2;

转载于:https://www.cnblogs.com/sellsa/p/9956846.html