[
https://issues.apache.org/jira/browse/HIVE-11649?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14900890#comment-14900890
]
Alan Gates commented on HIVE-11649:
-----------------------------------
<property>
<name>hive.txn.manager</name>
<value>org.apache.hadoop.hive.ql.lockmgr.DummyTxnManager</value>
<description>
Set to org.apache.hadoop.hive.ql.lockmgr.DbTxnManager as part of turning
on Hive
transactions, which also requires appropriate settings for
hive.compactor.initiator.on,
hive.compactor.worker.threads, hive.support.concurrency (true),
hive.enforce.bucketing
(true), and hive.exec.dynamic.partition.mode (nonstrict).
The default DummyTxnManager replicates pre-Hive-0.13 behavior and provides
no transactions.
</description>
</property>
This should be DbTxnManager if you want to use update and delete. It won't
work with DummyTxnManager. The reason it's taking a long time is when you set
the txn manager to Dummy and the concurrency to true you get the zookeeper lock
manager, which is taking time trying to connect to zookeeper.
> Hive UPDATE,INSERT,DELETE issue
> -------------------------------
>
> Key: HIVE-11649
> URL: https://issues.apache.org/jira/browse/HIVE-11649
> Project: Hive
> Issue Type: Bug
> Environment: Hadoop-2.2.0 , hive-1.2.0 ,operating system
> ubuntu14.04lts (64-bit) & Java 1.7
> Reporter: Veerendra Nath Jasthi
> Assignee: Hive QA
> Attachments: afterChange.png, beforeChange.png, hive-site.xml,
> hive.log
>
>
> have been trying to implement the UPDATE,INSERT,DELETE operations in hive
> table as per link:
> https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions#HiveTransactions-
>
> but whenever I was trying to include the properties which will do our work
> i.e.
> Configuration Values to Set for INSERT, UPDATE, DELETE
> hive.support.concurrency true (default is false)
> hive.enforce.bucketing true (default is false)
> hive.exec.dynamic.partition.mode nonstrict (default is strict)
> after that if I run show tables command on hive shell its taking 65.15
> seconds which normally runs at 0.18 seconds without the above properties.
> Apart from show tables rest of the commands not giving any output i.e. its
> keep on running until and unless kill the process.
> Could you tell me reason for this?
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
