Support Questions
Find answers, ask questions, and share your expertise

Ambari Blueprint 2.5 Hive MySql Error

Highlighted

Ambari Blueprint 2.5 Hive MySql Error

New Contributor

I'm using Ambari 2.5 Local repository, multinode installing.

while executing this

curl -H "X-Requested-By: ambari"-X POST -u admin:admin http://<ambari-server-hostname>:8080/api/v1/clusters/multinode-hdp -d @hostmap.json

I'm getting this error

curl -H "X-Requested-By: ambari" -X POST -u admin:admin http://35.227.17.212:8080/api/v1/clusters/SDC_Prod -d @hostmapping.json { "status" : 400, "message" : "Topology validation failed: org.apache.ambari.server.topology.InvalidTopologyException: Component [MYSQL_SERVER] must explicitly be set in the blueprint when hive database is configured with the current settings. HIVE service validation failed." }

Any solution?

4 REPLIES 4
Highlighted

Re: Ambari Blueprint 2.5 Hive MySql Error

Super Mentor

@Karan Mamtora

In your Blueprint JSOn have you defined the host_group components properly? Does it has the MySQL_SERVER defined something like following?

Example Snippet of Blueprint


     {
      "components" : [
        {
          "name" : "HIVE_SERVER"
        },
        {
          "name" : "MYSQL_SERVER"
        },
        {
          "name" : "HIVE_METASTORE"
        },
        {
          "name" : "HIVE_CLIENT"
        },
      ],
      "configurations" : [ ],
      "name" : "host_group_3",
      "cardinality" : "1"
    },

.

Means you will need to make sure that the MYSQL_SERVER component is defined inside the host_group definition in blueprint.

Highlighted

Re: Ambari Blueprint 2.5 Hive MySql Error

New Contributor

@Jay Kumar SenSharma

I have defined MYSQL_SERVER component, below is my cluster_config.json

{
 "configurations": [],
 "host_groups": [{
 "name": "host2",
 "components": [{
 "name": "PIG"
 }, {
 "name": "METRICS_COLLECTOR"
 }, {
 "name": "KAFKA_BROKER"
 }, {
 "name": "HISTORYSERVER"
 }, {
 "name": "HBASE_REGIONSERVER"
 }, {
 "name": "OOZIE_CLIENT"
 }, {
 "name": "HBASE_CLIENT"
 }, {
 "name": "NAMENODE"
 }, {
 "name": "SUPERVISOR"
 }, {
 "name": "HCAT"
 }, {
 "name": "METRICS_MONITOR"
 }, {
 "name": "APP_TIMELINE_SERVER"
 }, {
 "name": "NODEMANAGER"
 }, {
 "name": "HDFS_CLIENT"
 }, {
 "name": "HIVE_CLIENT"
 }, {
 "name": "FLUME_HANDLER"
 }, {
 "name": "DATANODE"
 }, {
 "name": "WEBHCAT_SERVER"
 }, {
 "name": "ZOOKEEPER_CLIENT"
 }, {
 "name": "ZOOKEEPER_SERVER"
 }, {
 "name": "STORM_UI_SERVER"
 }, {
 "name": "HIVE_SERVER"
 }, {
  "name" : "MYSQL_SERVER"
 }, {
 "name": "FALCON_CLIENT"
 }, {
 "name": "TEZ_CLIENT"
 }, {
 "name": "HIVE_METASTORE"
 }, {
 "name": "SQOOP"
 }, {
 "name": "YARN_CLIENT"
 }, {
 "name": "MAPREDUCE2_CLIENT"
 }, {
 "name": "NIMBUS"
 }, {
 "name": "DRPC_SERVER"
 }],
 "cardinality": "1"
 }, {
 "name": "host3",
 "components": [{
 "name": "ZOOKEEPER_SERVER"
 }, {
 "name": "OOZIE_SERVER"
 }, {
 "name": "SECONDARY_NAMENODE"
 }, {
 "name": "FALCON_SERVER"
 }, {
 "name": "ZOOKEEPER_CLIENT"
 }, {
 "name": "PIG"
 }, {
 "name": "KAFKA_BROKER"
 }, {
 "name": "OOZIE_CLIENT"
 }, {
 "name": "HBASE_REGIONSERVER"
 }, {
 "name": "HBASE_CLIENT"
 }, {
 "name": "HCAT"
 }, {
 "name": "METRICS_MONITOR"
 }, {
 "name": "FALCON_CLIENT"
 }, {
 "name": "TEZ_CLIENT"
 }, {
 "name": "SQOOP"
 }, {
 "name": "HIVE_CLIENT"
 }, {
 "name": "HDFS_CLIENT"
 }, {
 "name": "NODEMANAGER"
 }, {
 "name": "YARN_CLIENT"
 }, {
 "name": "MAPREDUCE2_CLIENT"
 }, {
 "name": "DATANODE"
 }],
 "cardinality": "1"
 }, {
 "name": "host4",
 "components": [{
 "name": "ZOOKEEPER_SERVER"
 }, {
 "name": "ZOOKEEPER_CLIENT"
 }, {
 "name": "PIG"
 }, {
 "name": "KAFKA_BROKER"
 }, {
 "name": "OOZIE_CLIENT"
 }, {
 "name": "HBASE_MASTER"
 }, {
 "name": "HBASE_REGIONSERVER"
 }, {
 "name": "HBASE_CLIENT"
 }, {
 "name": "HCAT"
 }, {
 "name": "RESOURCEMANAGER"
 }, {
 "name": "METRICS_MONITOR"
 }, {
 "name": "FALCON_CLIENT"
 }, {
 "name": "TEZ_CLIENT"
 }, {
 "name": "SQOOP"
 }, {
 "name": "HIVE_CLIENT"
 }, {
 "name": "HDFS_CLIENT"
 }, {
 "name": "NODEMANAGER"
 }, {
 "name": "YARN_CLIENT"
 }, {
 "name": "MAPREDUCE2_CLIENT"
 }, {
 "name": "DATANODE"
 }],
 "cardinality": "1"
 }],
 "Blueprints": {
 "blueprint_name": "multinode-hdp",
 "stack_name": "HDP",
 "stack_version": "2.5"
 }
}
Highlighted

Re: Ambari Blueprint 2.5 Hive MySql Error

New Contributor
@Jay Kumar SenSharma

can you provide me automation steps for 2.5 version using local repository

Highlighted

Re: Ambari Blueprint 2.5 Hive MySql Error

@karan mamtora

You can used attached blueprint steps to register the with local repo and create a blueprint

Note: Replace public URLs with private repos.bp-stepby-step-hdpversion.txt

Let me know if you have questions.

Note: Please mark the correct answer if this helps in solving the issue