ambari is not a GUI interface to Hive... It is an Hadoop cluster managment tool.
If you need a commandline compatible interface, you can use for instance using beeline. you can use a JDBC based GUI (like dbeaver) to access the data as long as the port is accessible. In older versions of ambari you could add some ambari views which had a query interface, though I do not know which work with the current versions of ambari. Kind Regards, J Julien Tane Big Data Engineer [Tel.] +49 721 98993-393 [Fax] +49 721 98993-66 [E-Mail] j...@solute.de<mailto:j...@solute.de> solute GmbH Zeppelinstra?e 15 76185 Karlsruhe Germany [Logo Solute] Marken der solute GmbH | brands of solute GmbH [Marken] Gesch?ftsf?hrer | Managing Director: Dr. Thilo Gans, Bernd Vermaaten Webseite | www.solute.de <http://www.solute.de/> Sitz | Registered Office: Karlsruhe Registergericht | Register Court: Amtsgericht Mannheim Registernummer | Register No.: HRB 110579 USt-ID | VAT ID: DE234663798 Informationen zum Datenschutz | Information about privacy policy https://www.solute.de/ger/datenschutz/grundsaetze-der-datenverarbeitung.php ________________________________ Von: Mich Talebzadeh <mich.talebza...@gmail.com> Gesendet: Montag, 15. Juni 2020 21:26:20 An: user Betreff: Running Hive queries from Ambari or from edge node via beeline Hi, I am not a user of Ambari but I believe it is a GUI interface to Hive. it can be run on your laptop and connect to Hive via ODBC or JDBC. There is also another tool DB Visualizer Pro that uses JDBC to connect to Hive thrift server. My view is that if one is a developer the best best would be to have access to the edge node and connect through beeline (Hive thrift server). This could be through Putty or SSH Tectia Secureshell but crucially since one is running on the Hadoop cluster (the edge node is part of the cluster on the same V-LAN), then the performance is expected to be better? also both Tectia SSH and Putty are thin clients so you are effectively running the code on the edge node as opposed through the client-server. Does this make sense? Thanks Mich LinkedIn https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw Disclaimer: Use it at your own risk. Any and all responsibility for any loss, damage or destruction of data or any other property which may arise from relying on this email's technical content is explicitly disclaimed. The author will in no case be liable for any monetary damages arising from such loss, damage or destruction.
