Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-11831

TXN tables in Oracle should be created with ROWDEPENDENCIES

    XMLWordPrintableJSON

    Details

    • Release Note:
      Hide
      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
      Show
      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

      Description

      These frequently-updated tables may otherwise suffer from spurious deadlocks.

        Attachments

        1. HIVE-11831.01.patch
          6 kB
          Sergey Shelukhin
        2. HIVE-11831.patch
          3 kB
          Sergey Shelukhin

          Activity

            People

            • Assignee:
              sershe Sergey Shelukhin
              Reporter:
              sershe Sergey Shelukhin
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: