hadoop-common-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Hadoop Wiki] Update of "Hive/HiveJDBCInterface" by BillGraham
Date Fri, 21 Aug 2009 05:35:33 GMT
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.
+ 
+ 
     
  

Mime
View raw message