How to setup custom database for ambari in HDInsight?

Federico Sardo 91 Reputation points
2023-03-27T19:50:48.9866667+00:00

Hi,

I am creating a hadoop cluster in HDInsight. For ambari I created an Azure SQL Database and during the creation I selected not to use existing data.

User's image

But when I want to create the cluster and try to select the database, I am facing this warning:

User's image

I am still getting the error even after I authenticate.

Any advice? Regards.

Azure HDInsight
Azure HDInsight
An Azure managed cluster service for open-source analytics.
198 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. PRADEEPCHEEKATLA-MSFT 76,921 Reputation points Microsoft Employee
    2023-03-28T09:51:37.0166667+00:00

    Hello @Federico Sardo,

    Thanks for the question and using MS Q&A platform.

    Could you please share the complete error message which you are experiencing?
    To resolve this issue, you can try to clear your browser cache and cookies, then try again.

    Hope this helps.

    0 comments
  2. Federico Sardo 91 Reputation points
    2023-03-28T10:52:24.53+00:00

    Hi @PRADEEPCHEEKATLA-MSFT

    I was able to create the cluster yester even with the warning message. Once the cluster was up and running I made some changes in the core-site.xml in order to have ambari taking care of it (since I guess that is the database for).

    In order to test that functionallity I destroyed the cluster and right now I am trying to recreate it. In the database section ofcourse I point to the custom ambari database. And when I submit the deployment using the portal I am getting this error :

    {"code":"DeploymentFailed","message":"At least one resource deployment operation failed. Please list deployment operations for details. Please see https://aka.ms/arm-deployment-operations for usage details.","details":[{"code":"BadRequest","message":"DeploymentDocument 'AmbariConfigurationValidator' failed the validation. Error: 'Custom Ambari Metastore DB 'dbambarihadoop' must be empty. Please remove the existing tables from the dbo schema'"}]}

    Could you please help me and clarify?

    Thanks

    Fede