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.

How to migrate Hive metastore from Azure SQL Database to local MySQL?

How to migrate Hive metastore from Azure SQL Database to local MySQL?

Contributor

I am trying to migrate the Hive metastore from Azure SQL Database to the local MySQL database without destroying the metadata for HDInsight cluster with LLAP Technical Preview. What are default credentials for Azure SQL Database and MySQL? Are there any scripts which make this easy?

Thank you

1 REPLY 1
Highlighted

Re: How to migrate Hive metastore from Azure SQL Database to local MySQL?

Guru

you can perform the mysqldump and copy over the dump file to your local mysql db and perform import.

Don't have an account?
Coming from Hortonworks? Activate your account here