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:13:40 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

------------------------------------------------------------------------------
  echo java -XX:MaxPermSize=512m -cp $CLASSPATH -jar launcher.jar
  java -XX:MaxPermSize=512m -cp $CLASSPATH org.pentaho.commons.launcher.Launcher}}}
   1.#3 Build and start the hive server with instructions from [wiki:Self:Hive/HiveServer
HiveServer]
-  1.#4 compile and run the hive jdbc client code to load some data (I havent figured out
how to do this in report designer yet). See [wiki:Self:Hive/HiveClient#head-fd2d8ae9e17fdc3d9b7048d088b2c23a53a6857d
sample code] for loading the data.
+  1.#4 compile and run the hive jdbc client code to load some data (I haven't figured out
how to do this in report designer yet). See [wiki:Self:Hive/HiveClient#head-fd2d8ae9e17fdc3d9b7048d088b2c23a53a6857d
sample code] for loading the data.
   1.#5 Run the report designer (note step 2)
     {{{
     $ sh reporter-designer.sh   }}}
@@ -43, +43 @@

   1.#13 Change the Report header to 'hive-pentaho-report'. Change the type of the header
to 'html'
   1.#14 Run the report and generate pdf. You should get something like the report attached
here.
  
+ === 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. 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].
+    {{{
+    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:
+    {{{
+    org.apache.hadoop.hive.jdbc.HiveDriver   }}}
+   1. Click "OK" to complete the driver registration.
+  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. 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. To connect to the Hive server, double-click the alias and click "Connect".
+    
+ 

Mime
View raw message