I am executing MigrateMetastore.sh from Master node of the Target HDInsight Cluster
We are using the default Hive metastore in both souce and target cluster.
I am facing issues while connecting to the metasore default server.
- metastoreserver should be the target server or the source server?
The SQL Server Hive metastore database URL for Target HDInsight CLauter in Ambari is as follows
jdbc:sqlserver://zlf4rz3oiy.database.windows.net;databaseName=v3660cd65711ea845cb8d75dd364a95d95ehivemetastore;trustServerCertificate=false;encrypt=true;hostNameInCertificate=*.database.windows.net;
i have used --metastoreserver 'zlf4rz3oiy.database.windows.net' --metastoredatabase hive and not able to connect to the Hive metastore database.
Any help would be appreciated?