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

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

    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.1.patch
          10 kB
          Anishek Agarwal
        2. HIVE-20152.2.patch
          11 kB
          Anishek Agarwal
        3. HIVE-20152.3.patch
          11 kB
          Anishek Agarwal
        4. HIVE-20152.4.patch
          11 kB
          Anishek Agarwal

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: