将Hive Metastore从HDInsight群集移动到Azure SQL

问题描述

大家好，

我创建了一个新的HDInsight群集（带有Hive），只选择了默认选项。在这种情况下，我忘了选择将Hive Metastore保留在AzureSQL中的选项。

我希望能够销毁并重新创建集群（使用脚本/ Azure自动化）但是我不能在Azure SQL上拥有Hive元数据。

我有没有办法将Hive元数据从它在HDInsight集群上的当前位置备份或移动到Azure SQL？  这样我可以删除群集并使用可用的元数据重建。

谢谢，

标记

解决方案

Hello Everyone,

I created a new HDInsight cluster (with Hive) and selected just the default options. In this case, I forgot to select the option to keep the Hive metastore in AzureSQL.

I want to be able to destroy and re-create the cluster (using script/Azure Automation) but can't as I don't have the Hive metadata already on Azure SQL.

Is there a way for me to backup or move the Hive metadata from it's current spot on the HDInsight cluster to Azure SQL?  That way I can delete the cluster and rebuild with the metadata being usable.

Thanks,

Mark

解决方案

这篇关于将Hive Metastore从HDInsight群集移动到Azure SQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！