Connecting SQuirrel SQL to Hive

Pre-requisites

In order to connect SQuirrel SQL client we need the following prerequisites,

1. Client – http://squirrel-sql.sourceforge.net/
2. Hive connection JARs (found in lib directories)
   1. Hive JDBC JAR – hive-jdbc-1.2.1-standalone.jar
   2. Hadoop common JAR (for ) – hadoop-common-2.7.2.jar
3. Running HiveServer2 instance

For connections use the following parameters in SQL client

Connection URL – jdbc:hive://www.robin.eu.org:10000/default

Driver class – org.apache.hive.jdbc.HiveDriver

References

1. https://community.hortonworks.com/questions/830/how-to-do-i-get-the-hive-jdbc-driver-for-my-clinet.html
2. https://community.hortonworks.com/repos/33592/hive-jdbc-uber-jar.html
3. https://github.com/timveil/hive-jdbc-uber-jar/releases