many thanks Julien much appreciated.
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. On Mon, 15 Jun 2020 at 22:09, Julien Tane <j...@solute.de> wrote: > 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 > > [image: Tel.] +49 721 98993-393 > [image: Fax] +49 721 98993-66 > [image: E-Mail] j...@solute.de > > solute GmbH > Zeppelinstraße 15 > 76185 Karlsruhe > Germany > > > [image: Logo Solute] > > Marken der solute GmbH | brands of solute GmbH > [image: Marken] > Geschäftsführer | Managing Director: Dr. Thilo Gans, Bernd Vermaaten > Webseite | 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 > <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. > > >
