Thanks Alejandro, however this is only going to give us the values for the keys in hive-site. The jdbc url itself will still need to be constructed using zk quorum, service discovery string keys. Isn't there an easier way to just fetch the url, which ambari server anyways displays on its GUI for the Hive service?
Regards Shirsha From: Alejandro Fernandez [mailto:afernan...@hortonworks.com] Sent: Tuesday, June 20, 2017 5:40 AM To: user@ambari.apache.org; Ray Chaudhuri, Shirsha (Nokia - IN/Bangalore) <shirsha.ray_chaudh...@nokia.com> Subject: Re: Retrieving JDBC URLs from Ambari Server This should all be available via the API, e.g., api/v1/clusters/$name/configurations?type=hive-site&tag=$latest Grabbing the latest config tag requires comparing the timestamps The Ambari Shell client may also have this logic already, same with /var/lib/ambari-server/resources/scripts/configs.sh get $ambari_server_ip $clustername hive-site $configkey Thanks, Alejandro From: "<Ray Chaudhuri>", "Shirsha (Nokia - IN/Bangalore)" <shirsha.ray_chaudh...@nokia.com<mailto:shirsha.ray_chaudh...@nokia.com>> Reply-To: "user@ambari.apache.org<mailto:user@ambari.apache.org>" <user@ambari.apache.org<mailto:user@ambari.apache.org>> Date: Monday, June 19, 2017 at 5:31 AM To: "user@ambari.apache.org<mailto:user@ambari.apache.org>" <user@ambari.apache.org<mailto:user@ambari.apache.org>> Subject: Retrieving JDBC URLs from Ambari Server Hi, Is there a way to retrieve the jdbc url for HiveServer2, Spark Thrift Server etc, using Ambari REST APIs? Regards Shirsha