hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sergey Shelukhin (JIRA)" <>
Subject [jira] [Updated] (HIVE-11831) TXN tables in Oracle should be created with ROWDEPENDENCIES
Date Fri, 25 Sep 2015 01:13:04 GMT


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:
>             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

View raw message