Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Restore backup hive metastore

Solved Go to solution

Restore backup hive metastore

Super Collaborator

Hi:

I have locally in a postgres database the hivemetastore, but now we will migrate to a remote metastore with a postgres database also

-Is necesary to migrate the hive metastore database to the new postgres instance?

-Is necesary to shut down the cluster?

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Restore backup hive metastore

@Roberto Sancho

1. If you need any detail from the backup then you MUST migrate the hive metastore backup to new postgres instance.

2. To ensure that the backup is applied correctly and that there are no inconsistencies, you must shut down the Hive Instance/Metastore then apply the backup, do quick consistency checks and then restart hive metastore and the instance.

3. You only need to shutdown Hive Metastore/Instance. No other component needs to be shutdown.

3 REPLIES 3

Re: Restore backup hive metastore

@Roberto Sancho

1. If you need any detail from the backup then you MUST migrate the hive metastore backup to new postgres instance.

2. To ensure that the backup is applied correctly and that there are no inconsistencies, you must shut down the Hive Instance/Metastore then apply the backup, do quick consistency checks and then restart hive metastore and the instance.

Highlighted

Re: Restore backup hive metastore

Super Collaborator

Many thanks for the information!!

Is not necesary to shut down de Namenode?

thanks

Re: Restore backup hive metastore

@Roberto Sancho

1. If you need any detail from the backup then you MUST migrate the hive metastore backup to new postgres instance.

2. To ensure that the backup is applied correctly and that there are no inconsistencies, you must shut down the Hive Instance/Metastore then apply the backup, do quick consistency checks and then restart hive metastore and the instance.

3. You only need to shutdown Hive Metastore/Instance. No other component needs to be shutdown.