hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Srinivas Thunga <>
Subject Re: Hive Transactions fail
Date Thu, 05 Mar 2015 11:30:06 GMT

After seeing your mail, i came to know that you are trying to update and
delete operations on Hive 1.0.

For doing the same,

After extracting Hive version, you have to create Hive meta store

Then in hive-site.xml, you need set the new parameters like – true
 hive.enforce.bucketing – true
 hive.exec.dynamic.partition.mode – nonstrict
 hive.txn.manager – org.apache.hadoop.hive.ql.lockmgr.DbTxnManager
 hive.compactor.initiator.on – true
 hive.compactor.worker.threads – 1

Then restart Hive-server and Metastore

Now create one normal table and one external table with orc format

and load from normal to orc table

Now you can update and delete records.

Let me know any concerns.

*Thanks & Regards,*

*Srinivas T*

On Thu, Mar 5, 2015 at 4:51 PM, David Simoes <> wrote:

> Ive had some troubles enabling transactions in Hive 1.0.0 and Ive made a
> post in
> Could anyone check it out and give me some pointers on why things are
> crashing?
> Tyvm, Dave

View raw message