Hi ,
I am getting following errorhi in cdh 5.4.2
FAILED: SemanticException [Error 10294]: Attempt to do update or delete using transaction manager that does not support these operations.
I followed the steps and limitations:
Following are my steps........
1. New Configuration Parameters for Transactions
2. Creates Hive table with ACID support
3. Load data into Hive table
4. Do UPDATE,DELETE and INSERT
set hive.support.concurrency=true; set hive.enforce.bucketing=true; set hive.exec.dynamic.partition.mode=nonstrict; set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager; set hive.compactor.initiator.on=true; set hive.compactor.worker.threads=2;
CREATE TABLE abc1 ( empwork_key int, empwork_id int, empwork__name string, empwork_email string, emp_wrk_phone string, CLUSTERED BY (empwork_id) into 2 buckets STORED AS ORC TBLPROPERTIES ('transactional' = 'true');
-- the data is inserted from an external table which is textfile format.
INSERT INTO TABLE abc1 SELECT empwork_key , empwork_id , empwork_name, empwork_email , emp_wrk_phone , FROM test.abc1 ;
update abc1 SET empwork_name = "Raj" where empwork_key = 70;
Please help if any suggestions or configuration changes needed.
I am setting all properties from hive shell
... View more
