Make sure you have configured these properties hive-site.xml
hive.support.concurrency
hive.enforce.bucketing
hive.exec.dynamic.partition.mode
hive.txn.manager
hive.compactor.initiator.on
hive.compactor.worker.threads
also following property has been set at table level
TBLPROPERTIES('transactional'='true')
Regards
Sanjiv Singh
Mob : +091 9990-447-339
On Mon, Nov 24, 2014 at 1:58 PM, Nitin Pawar <nitinpawar...@gmail.com>
wrote:
> whats your create table DDL?
> On 24 Nov 2014 13:43, "unmesha sreeveni" <unmeshab...@gmail.com> wrote:
>
>> Hi
>>
>> I am using hive -0.14.0 which support UPDATE statement
>>
>> but I am getting an error once I did this Command
>> UPDATE Emp SET salary = 50000 WHERE employeeid = 19;
>>
>> FAILED: SemanticException [Error 10294]: Attempt to do update or delete
>> using transaction manager that does not support these operations.
>> hive>
>>
>>
>> Am I doing anything wrong?
>>
>> --
>> *Thanks & Regards *
>>
>>
>> *Unmesha Sreeveni U.B*
>> *Hadoop, Bigdata Developer*
>> *Centre for Cyber Security | Amrita Vishwa Vidyapeetham*
>> http://www.unmeshasreeveni.blogspot.in/
>>
>>
>>
