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

Error:

Resolution:

        1.     Check if Your table storage format is ORC

        2.     Check if your table is partitioned and bucketed, if not do partition and bucket

        3.     Check all the below configurations from ambari or Hive_site.xml

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

4.     After that try to update the records

Read More