Hi, We use Postgres as the database for Ambari and Hive. We made a backup of it prior to making any changes. We rolled back to the database copy where we didn't have any issues with consistency, duplicate key issues etc. After we rolled back and started from scratch again we didn't have any issues. Sorry, beyond that we didn't have to try anything else. Hopefully that helps.
... View more