ambari external metastore must be empty

[#1]

Hi,

After recreating hadoop cluster on HDInsight and connecting to the external metastore I get an error "Custom Ambari Metastore DB must be empty". Why I get this error? The goal was to keep all the metadata in external DB in case to preserve these data every time when I delete and recreate the cluster.

[#2 · Accepted solution]

@Damian_S You cannot delete and recreate a hadoop cluster in this manner.  The data in the metastore is very specific to the previous installation.   A proper migration will back up the required artifacts from the original cluster, and migrate them to a new existing ambari cluster that has already completed the initial cluster installation.