[
https://issues.apache.org/jira/browse/HIVE-11831?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14900960#comment-14900960
]
Alan Gates commented on HIVE-11831:
-----------------------------------
+1, patch itself looks good.
When you say no possibility of upgrade, do we need to build a recommended
procedure for people to migrate their data so they can fix the deadlocks if
they are already using this feature in Oracle? Something like:
# pause the world
# create temp table
# move contents of existing table to temp table
# drop existing table
# create new table with ROWDEPENDENCIES
# move data back from temp table
> TXN tables in Oracle should be created with ROWDEPENDENCIES
> -----------------------------------------------------------
>
> Key: HIVE-11831
> URL: https://issues.apache.org/jira/browse/HIVE-11831
> Project: Hive
> Issue Type: Bug
> Reporter: Sergey Shelukhin
> Assignee: Sergey Shelukhin
> Attachments: HIVE-11831.01.patch, HIVE-11831.patch
>
>
> These frequently-updated tables may otherwise suffer from spurious deadlocks.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
