...
- Download, install and start the SQuirrel SQL Client from the SQuirrel SQL website.
- Select 'Drivers -> New Driver...' to register the Hive JDBC driver.
Enter the driver name and example URL:
Code Block Name: Hive Example URL: jdbc:hive2hive://localhost:10000/default
Select 'Extra Class Path -> Add' to add the following jars from your local Hive and Hadoop distribution. You will need to build Hive from the trunk after the commit of HIVE-679.
Code Block HIVE_HOME/build/dist/lib/*.jar HADOOP_HOME/hadoop-*-core.jar
Select 'List Drivers'. This will cause SQuirrel to parse your jars for JDBC drivers and might take a few seconds. From the 'Class Name' input box select the Hive driver:
Code Block org.apache.hadoop.hive.jdbc.HiveDriver
- Click 'OK' to complete the driver registration.
...