Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Restore backup hive metastore

avatar
Master 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

avatar

@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.

View solution in original post

3 REPLIES 3

avatar
@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.

avatar
Master Collaborator

Many thanks for the information!!

Is not necesary to shut down de Namenode?

thanks

avatar

@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.