title: HIVE 1.x ACID features - Update and DELETE are not working
body: <p>As a part of HIVE 1.x ACID features, Update and Delete should work on ORC file tables (I am trying this in Cloudera CDH 5.4.4)</p>
  
  <p>However, I see its not working. Can someone suggest.
  Error: </p>
  
  <blockquote>
    <p>FAILED: SemanticException [Error 10294]: Attempt to do update or
    delete using transaction manager that does not support these
    operations.</p>
  </blockquote>
  
  <p>Here is the table I created </p>
  
  <pre><code>create table table2_test (EmployeeID Int, FirstName String, Designation String,
  Salary Int,Department String) 
  clustered by (department) into 3 buckets 
  stored as orc TBLPROPERTIES ('transactional'='true');
  </code></pre>
  
  <p>CLI Prompt:</p>
  
  <pre><code>    &gt; set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
  hive&gt; set hive.compactor.initiator.on=true;
  hive&gt; set hive.compactor.worker.threads=1;
  hive&gt; set hive.support.concurrency=true;
  hive&gt; set hive.enforce.bucketing=true;
  hive&gt; set hive.exec.dynamic.partition.mode=nonstrict;
  hive&gt; Insert into table2_test values (102, 'Employee102','Designation102', 10101, 'Dept102'), (103, 'Employee103','Designation103', 10102, 'Dept103');
  ...........
  Stage-Stage-1: Map: 1  Reduce: 3   Cumulative CPU: 9.14 sec   HDFS Read: 15568 HDFS Write: 1323 SUCCESS
  Total MapReduce CPU Time Spent: 9 seconds 140 msec
  OK
  Time taken: 48.727 seconds
  hive&gt; update table2_test set salary=111111 where employeeid=20;
  FAILED: SemanticException [Error 10294]: Attempt to do update or delete using transaction manager that does not support these operations.
  hive&gt; delete from table2_test where employeeid=19;
  FAILED: SemanticException [Error 10294]: Attempt to do update or delete using transaction manager that does not support these operations.
  </code></pre>