hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alan Gates (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-11831) TXN tables in Oracle should be created with ROWDEPENDENCIES
Date Mon, 21 Sep 2015 16:47:04 GMT

    [ 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)

Mime
View raw message