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)
