How to pass hive password in Ambari Blueprint

[Pratik Gadiya]

Hi All,

When I try to pass hive metastore password using Ambari blueprint the password 
doesn't gets reflected in the Ambari UI.
I think due to which my hive services i.e. both hive server 2 and hive 
metastore are failing to start.

Ambari UI Hive Config:-

[cid:image001.png@01D05FED.1791E6B0]

For refence, below are is my blueprint and host mapping file,

myblueprint.json:-

{
  "configurations" : [
  {
    "hive-env": {
      "hive_metastore_user_passwd": "root123"
    }
  }
  ],
  "host_groups" : [
    {
      "name" : "slave",
      "configurations" : [ ],
      "components" : [
        {          "name" : "ZOOKEEPER_SERVER"        },
        {          "name" : "ZOOKEEPER_CLIENT"        },
        {          "name" : "PIG"        },
        {          "name" : "OOZIE_CLIENT"        },
        {          "name" : "HBASE_CLIENT"        },
        {          "name" : "HCAT"        },
        {          "name" : "FALCON_CLIENT"        },
        {          "name" : "TEZ_CLIENT"        },
        {          "name" : "SLIDER"        },
        {          "name" : "SQOOP"        },
        {          "name" : "HDFS_CLIENT"        },
        {          "name" : "HIVE_CLIENT"        },
        {          "name" : "NODEMANAGER"        },
        {          "name" : "YARN_CLIENT"        },
        {          "name" : "MAPREDUCE2_CLIENT"        },
        {          "name" : "DATANODE"        },
        {          "name" : "GANGLIA_MONITOR"        }
      ],
      "cardinality" : "1000"
    },
    {
      "name" : "master",
      "configurations" : [ ],
      "components" : [
        {          "name" : "PIG"        },
        {          "name" : "HISTORYSERVER"        },
        {          "name" : "KAFKA_BROKER"        },
        {          "name" : "HBASE_REGIONSERVER"        },
        {          "name" : "OOZIE_CLIENT"        },
        {          "name" : "HBASE_CLIENT"        },
        {          "name" : "NAMENODE"        },
        {          "name" : "SUPERVISOR"        },
        {          "name" : "FALCON_SERVER"        },
        {          "name" : "HCAT"        },
        {          "name" : "KNOX_GATEWAY"        },
        {          "name" : "SLIDER"        },
        {          "name" : "AMBARI_SERVER"        },
        {          "name" : "APP_TIMELINE_SERVER"        },
        {          "name" : "HDFS_CLIENT"        },
        {          "name" : "HIVE_CLIENT"        },
        {          "name" : "FLUME_HANDLER"        },
        {          "name" : "WEBHCAT_SERVER"        },
        {          "name" : "RESOURCEMANAGER"        },
        {          "name" : "ZOOKEEPER_SERVER"        },
        {          "name" : "ZOOKEEPER_CLIENT"        },
        {          "name" : "STORM_UI_SERVER"        },
        {          "name" : "HBASE_MASTER"        },
        {          "name" : "HIVE_SERVER"        },
        {          "name" : "OOZIE_SERVER"        },
        {          "name" : "FALCON_CLIENT"        },
        {          "name" : "SECONDARY_NAMENODE"        },
        {          "name" : "TEZ_CLIENT"        },
        {          "name" : "HIVE_METASTORE"        },
        {          "name" : "GANGLIA_SERVER"        },
        {          "name" : "SQOOP"        },
        {          "name" : "YARN_CLIENT"        },
        {          "name" : "MAPREDUCE2_CLIENT"        },
        {          "name" : "MYSQL_SERVER"        },
        {          "name" : "GANGLIA_MONITOR"        },
        {          "name" : "DRPC_SERVER"        },
        {          "name" : "NIMBUS"        }
      ],
      "cardinality" : "1"
    }
  ],
  "Blueprints" : {
    "stack_name" : "HDP",
    "stack_version" : "2.2"
  }
}

host_mapping.json:-

{
    "blueprint": "myblueprint",
    "default_password" : "root123",
    "host_groups": [
        {
            "name": "master",
            "hosts": [
                {
                    "fqdn": "pratikmaster.xxx.com"
                }
            ]
        },
        {
            "name": "slave",
            "hosts": [
                {
                    "fqdn": "pratikcompute.xxx.com"
                }
            ]
        }
    ]
}


Please let me know if any additional changes are required in myblueprint.json 
or host_mapping.json to pass the hive passwoord value appropriately.

Thanks,
Pratik


DISCLAIMER
==========
This e-mail may contain privileged and confidential information which is the 
property of Persistent Systems Ltd. It is intended only for the use of the 
individual or entity to which it is addressed. If you are not the intended 
recipient, you are not authorized to read, retain, copy, print, distribute or 
use this message. If you have received this communication in error, please 
notify the sender and delete all copies of this message. Persistent Systems 
Ltd. does not accept any liability for virus infected mails.