hadoop - 删除或更新操作在配置单元 0.14 上不起作用

Question

任何人都知道为什么删除/更新操作在配置单元 0.14 中不起作用(它应该从 0.14 版本开始工作)即使我确实按照步骤/格式创建表并得到:

FAILED: SemanticException [Error 10294]: Attempt to do update or delete using transaction manager that does not support these operations.

运行删除操作。请帮我解决这个问题。

CREATE TABLE STUDENT
(
STD_ID INT,
STD_NAME STRING,
AGE INT,
ADDRESS STRING
)
CLUSTERED BY (ADDRESS) into 3 buckets
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
STORED as orc tblproperties('transactional'='true');

Answer 1

从 0.14 开始删除和更新作品。我能够实现同样的目标。您需要在 Hive 中设置新的配置参数

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

然后创建一个支持 ACID 的表，

     CREATE TABLE STUDENT
(
STD_ID INT,
STD_NAME STRING,
AGE INT,
ADDRESS STRING
)
CLUSTERED BY (ADDRESS) into 3 buckets
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
STORED as orc tblproperties('transactional'='true');

并进行 CURD 操作。

update STUDENT 
    set AGE = 24 
    where STD_ID = 19; 

请关注这些 steps