[
https://issues.apache.org/jira/browse/HIVE-12634?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15278686#comment-15278686
]
Wei Zheng commented on HIVE-12634:
----------------------------------
ROLLBACK is supposed to be used within a BEGIN TRANSACTION/END TRANSACTION
block.
ABORT TRANSACTIONS is used separately to clean up dangling or failing
transactions. With this, users don't need to query against the metastore db
directly if they want to delete some failed transaction records.
> Add command to kill an ACID transaction
> ---------------------------------------
>
> Key: HIVE-12634
> URL: https://issues.apache.org/jira/browse/HIVE-12634
> Project: Hive
> Issue Type: New Feature
> Components: Transactions
> Affects Versions: 1.0.0
> Reporter: Eugene Koifman
> Assignee: Wei Zheng
> Labels: TODOC1.3, TODOC2.1
> Fix For: 1.3.0, 2.1.0
>
> Attachments: HIVE-12634.1.patch, HIVE-12634.2.patch,
> HIVE-12634.3.patch, HIVE-12634.4.patch, HIVE-12634.5.patch,
> HIVE-12634.6.patch, HIVE-12634.7.patch, HIVE-12634.branch-1.patch
>
>
> Should add a CLI command to abort a (runaway) transaction.
> This should clean up all state related to this txn.
> The initiator of this (if still alive) will get an error trying to
> heartbeat/commit, i.e. will become aware that the txn is dead.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
