hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "@Sanjiv Singh" <sanjiv.is...@gmail.com>
Subject Re: UPDATE in Hive -0.14.0
Date Mon, 24 Nov 2014 08:39:59 GMT
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 <nitinpawar432@gmail.com>
wrote:

> whats your create table DDL?
> On 24 Nov 2014 13:43, "unmesha sreeveni" <unmeshabiju@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/
>>
>>
>>

Mime
View raw message