Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-18320 Support ACID Tables Replication
  3. HIVE-18988

Support bootstrap replication of ACID tables

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersConvert to IssueMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    Description

      Bootstrapping of ACID tables, need special handling to replicate a stable state of data.

      • If ACID feature enables, then perform bootstrap dump for ACID tables with in read txn.
        -> Dump table/partition metadata.
        -> Get the list of valid data files for a table using same logic as read txn do.
        -> Dump latest ValidWriteIdList as per current read txn.
      • Set the valid last replication state such that it doesn't miss any open txn started after triggering bootstrap dump.
      • If any txns on-going which was opened before triggering bootstrap dump, then it is not guaranteed that if open_txn event captured for these txns. Also, if these txns are opened for streaming ingest case, then dumped ACID table data may include data of open txns which impact snapshot isolation at target. To avoid that, bootstrap dump should wait for timeout (new configuration: hive.repl.bootstrap.dump.open.txn.timeout). After timeout, just force abort those txns and continue.
      • If any txns force aborted belongs to a streaming ingest case, then dumped ACID table data may have aborted data too. So, it is necessary to replicate the aborted write ids to target to mark those data invalid for any readers.

      Attachments

        1. HIVE-18988.01.patch
          1.42 MB
          Sankar Hariappan
        2. HIVE-18988.01-branch-3.patch
          1.48 MB
          Sankar Hariappan
        3. HIVE-18988.02.patch
          1.42 MB
          Sankar Hariappan
        4. HIVE-18988.03.patch
          1.42 MB
          Sankar Hariappan
        5. HIVE-18988.04.patch
          1.48 MB
          Sankar Hariappan
        6. HIVE-18988.05.patch
          1.47 MB
          Sankar Hariappan
        7. HIVE-18988.06.patch
          1.48 MB
          Sankar Hariappan
        8. HIVE-18988.07.patch
          1.48 MB
          Sankar Hariappan

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            sankarh Sankar Hariappan Assign to me
            sankarh Sankar Hariappan
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment