Connecting to Hive using external tool



I have an application running on my local desktop. I would like to connect to the Hive database using my application/tool. Is there anyway we can connect. Please let me know.


Practice hive on state of the art Big Data cluster -


One way could be using Cloudera ODBC driver.

I did a small test recently. I installed Cloudera ODBC drivers on my laptop and used those to connect MS Excel with Hive running on Cloudera VM.


Hi. I want to connect to itversity instance of Hive.


I doubt if it will work. You have to be in itversity network to connect local application to Hive. Wait for one of the sysadmins to confirm