Hive Transactions fail

[David Simoes <da...@ua.pt>]

Ive had some troubles enabling transactions in Hive 1.0.0 and Ive made a post in
http://stackoverflow.com/questions/28867368/hive-transactions-are-crashing

Could anyone check it out and give me some pointers on why things are crashing?

Tyvm, Dave

Re: Hive Transactions fail

[Srinivas Thunga <sr...@gmail.com>]

Hi,

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

http://www.cloudera.com/content/cloudera/en/documentation/cdh5/v5-1-x/CDH5-Installation-Guide/cdh5ig_hive_metastore_configure.html

Then in hive-site.xml, you need set the new parameters like

 hive.support.concurrency – 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 <da...@ua.pt> wrote:

> Ive had some troubles enabling transactions in Hive 1.0.0 and Ive made a
> post in
> http://stackoverflow.com/questions/28867368/hive-transactions-are-crashing
>
> Could anyone check it out and give me some pointers on why things are
> crashing?
>
> Tyvm, Dave
>
>