Thanks Sumit. Have you used the Knox Gateway with Ambari? Am just curious, how that gets configured with the target URLs? Does that do the same, construct the url after fetching the key-values?
Regards Shirsha From: Sumit Mohanty [mailto:smoha...@hortonworks.com] Sent: Wednesday, June 21, 2017 10:09 AM To: user@ambari.apache.org; Alejandro Fernandez <afernan...@hortonworks.com>; user@ambari.apache.org Subject: Re: Retrieving JDBC URLs from Ambari Server I believe the jdbc url is not stored as a single value in any of the configs. UI does the same too. So you may have read the individual values and construct the url. Get Outlook for iOS<https://aka.ms/o0ukef> _____________________________ From: Ray Chaudhuri, Shirsha (Nokia - IN/Bangalore) <shirsha.ray_chaudh...@nokia.com<mailto:shirsha.ray_chaudh...@nokia.com>> Sent: Tuesday, June 20, 2017 8:59 PM Subject: RE: Retrieving JDBC URLs from Ambari Server To: Alejandro Fernandez <afernan...@hortonworks.com<mailto:afernan...@hortonworks.com>>, <user@ambari.apache.org<mailto:user@ambari.apache.org>> 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 [ Alejandro Fernandez [mailto:afernan...@hortonworks.com] Sent: Tuesday, June 20, 2017 5:40 AM To: user@ambari.apache.org<mailto:user@ambari.apache.org>; Ray Chaudhuri, Shirsha (Nokia - IN/Bangalore) <shirsha.ray_chaudh...@nokia.com<mailto: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