Tag Archives: Hive Update and Delete Error

[Solved] Hive Update and Delete Error: Attempt to do update or delete using transaction manager

By default, there is no default support for single insert (update), update and delete (delete) operations in hive, you need to configure it yourself. And by default, when a user uses the update and delete operations, the following happens.
hive> update dp set name=’beijing’ where id=1159;
FAILED: SemanticException [Error 10294]: Attempt to do update or delete using transaction manager that does not support these operations.

The following is a step-by-step guide to enable the update and delete functions.
1. In the hive-site.xml file, add the following attributes.

<name>hive.support.concurrency</name>
<value>true</value

<name>hive.force.bucketing</name
<value>true</value>

<name>hive.exec.dynamic.partition.mode</name
<value>nonstrict</value>

<name>hive.txn.manager</name>
<value>org.apache.hadoop.hive.ql.lockmgr.DbTxnManager</value>

<name>hive.compactor.initiator.on</name
<value>true</value>

<name>hive.compactor.worker.threads</name
<value>1</value>

<name>hive.in.test</name
<value>true</value>

2. restarting the hive service.

3. Create the table.
create table student(
id int,
name String,
sex varchar(2),
birthday varchar(10),
major varchar(1)
) clustered by (id) into 2 buckets stored as orc TBLPROPERTIES(‘transactional’=’true’);

4, test update, delete statement
hive> update student set name=’beijing’ where id=1159;

Modify successfully. The frequent update and delete operations have defeated the original purpose of hive. As a last resort, it is best to use the incremental add method.