Dear Wiki user, You have subscribed to a wiki page or wiki category on "Hadoop Wiki" for change notification.
The following page has been changed by BillGraham: http://wiki.apache.org/hadoop/Hive/HiveJDBCInterface ------------------------------------------------------------------------------ === Integration with SQuirrel SQL Client === 1. Download, install and start the SQuirrel SQL Client from the [http://squirrel-sql.sourceforge.net/ SQuirrel SQL website]. - 1. Select "Drivers -> New Driver..." to register the Hive JDBC driver. + 1. Select 'Drivers -> New Driver...' to register the Hive JDBC driver. 1. Enter the driver name and example URL: {{{ Name: Hive Example URL: jdbc:hive://localhost:10000/default }}} - 1. 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 [https://issues.apache.org/jira/browse/HIVE-679 HIVE-679]. + 1. 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 [https://issues.apache.org/jira/browse/HIVE-679 HIVE-679]. {{{ HIVE_HOME/build/dist/lib/*.jar HADOOP_HOME/hadoop-*-core.jar }}} - 1. 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: + 1. 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: {{{ org.apache.hadoop.hive.jdbc.HiveDriver }}} - 1. Click "OK" to complete the driver registration. + 1. Click 'OK' to complete the driver registration. - 1. Select "Aliases -> Add Alias..." to create a connection alias to your Hive server. + 1. Select 'Aliases -> Add Alias...' to create a connection alias to your Hive server. - 1. Give the connection alias a name in the "Name" input box. + 1. Give the connection alias a name in the 'Name' input box. - 1. Select the Hive driver from the "Driver" drop-down. + 1. Select the Hive driver from the 'Driver' drop-down. 1. Modify the example URL as needed to point to your Hive server. - 1. Leave "User Name" and "Password" blank and click "OK" to save the connection alias. + 1. Leave 'User Name' and 'Password' blank and click 'OK' to save the connection alias. - 1. To connect to the Hive server, double-click the alias and click "Connect". + 1. To connect to the Hive server, double-click the Hive alias and click 'Connect'. + + When the connection is established you will see errors in the log console and might get a warning that the driver is not JDBC 3.0 compatible. These alerts are due to yet-to-be-implemented parts of the JDBC metadata API and can safely be ignored. To test the connection enter =SHOW TABLES= in the console and click the run icon. + + Also note that when a query is running, support for the "Cancel" button is not yet available. + +
