[
https://issues.apache.org/jira/browse/HIVE-11831?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sergey Shelukhin updated HIVE-11831:
------------------------------------
Release Note:
ROWDEPENDENCIES cannot be added to the table after it has already been created.
If you hit this issue on an existing database, you might want to (this requires
stopping all Hive workloads for the duration), for each table (see the patch
for what tables need to be updated; locks and txns table are the ones most
affected):
1) create temp table
2) move contents of existing table to temp table
3) drop existing table
4) create new table with ROWDEPENDENCIES, as per the attached patch
5) 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
> Fix For: 2.0.0
>
> 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)
