Bibin Joseph created HIVE-13535: ----------------------------------- Summary: UPDATE ... SET only working when properties are set globally. Key: HIVE-13535 URL: https://issues.apache.org/jira/browse/HIVE-13535 Project: Hive Issue Type: Bug Components: Hive Environment: Operating System : SUSE Linux Enterprise Server 11 (x86_64) Architecture : x86_64 CPU op-mode(s) : 32-bit, 64-bit Byte Order : Little Endian Hadoop version : Hadoop 2.7.1.2.3.2.0-2950 Hive version : Hive 1.2.1.2.3.2.0-2950
Reporter: Bibin Joseph Priority: Minor h3.Making a hive table transactional *Steps followed* 1. Entered hive shell. 2. Choose database. 3. Set hive transaction properties. {quote} 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=1; SET hive.support.concurrency=true; SET hive.enforce.bucketing=true; {quote} 4. Created bucketed table with 'transactional'='true' {quote} create table test(id int, name string) clustered by (id) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true'); {quote} 5. Inserted values. {quote} insert into table test values(1,'Name'); {quote} 6. Fired update query. {quote} update test set name='New_Name' where id=1; {quote} Created following error ; {quote} FAILED: SemanticException [Error 10294]: Attempt to do update or delete using transaction manager that does not support these operations. {quote} *It works without error when the transaction properties are set, before choosing database.* -- This message was sent by Atlassian JIRA (v6.3.4#6332)