[jira] [Updated] (HIVE-13535) UPDATE ... SET only working when properties are set globally.

["Bibin Joseph (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-13535?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Bibin Joseph updated HIVE-13535:
--------------------------------
    Priority: Major  (was: Minor)

> 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
>
> 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)