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 <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.
