Monday, February 20, 2017

Hive update , delete and insert ERROR in cdh 5.4.2


Getting following errorhi in cdh 5.4.2 

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

Solution :

hive.auto.convert.join.noconditionaltask.size = 10000000;
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 ;

No comments:

Post a Comment

How To Fix Hive – Partition Table Query Failed When Stored As Parquet

This article is about the bug in Hive filtering option, when the partition table query stored as parquet. Big data developers will help y...