Using Squirrel to query Hive

To use squirrel download the following jar files (I am using hive 1.2.1). The first Jar file is the actual driver and others are the dependencies the driver has

• hive-jdbc-1.2.1.jar
• hadoop-common-2.7.1.jar
• hive-service-1.2.1.jar
• libthrift-0.9.3.jar
• httpclient-4.5.1.jar
• httpcore-4.4.4.jar
• hive-metastore-1.2.1.jar
• hive-exec-1.2.1.jar
• slf4j-api-1.7.13.jar

Assuming you already have squirrel installed, (if not go to http://squirrel-sql.sourceforge.net/#installation ), Go to driver, click on the + sign to register a new driver.

Add the downloaded Jar files here.
Click on hive-jdbc jar files and click "list drivers"
Give the example URL as jdbc:hive2://localhost:10000/default

And click Ok.

Now create an alias, and provide the server details and username and connect

You are good to use Squirrel. I like the tool except for the fact that you can not have the object browser and SQL window side by side. (Or there may be a way, I am not aware of)