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

reset db state, when repl dump fails, so rename table can be done

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    Description

      If a repl dump command is run and it fails for some reason while doing table level dumps, the state set on the db parameters is not reset and hence no table / partition renames can be done.

      the property to be reset is prefixed with key 

      bootstrap.dump.state

      and it should be unset. meanwhile the workaround is 

      describe database extended [db_name];

      assuming property is 'bootstrap.dump.state.something'

      alter  database [db_name] set dbproperties ('bootstrap.dump.state.something'='idle');"

      Attachments

        1. HIVE-20152.4.patch
          11 kB
          Anishek Agarwal
        2. HIVE-20152.3.patch
          11 kB
          Anishek Agarwal
        3. HIVE-20152.2.patch
          11 kB
          Anishek Agarwal
        4. HIVE-20152.1.patch
          10 kB
          Anishek Agarwal

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

          People

            anishek Anishek Agarwal Assign to me
            anishek Anishek Agarwal
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment