You are viewing a plain text version of this content. The canonical link for it is here.
Posted to common-commits@hadoop.apache.org by Apache Wiki <wi...@apache.org> on 2009/08/21 07:13:40 UTC
[Hadoop Wiki] Update of "Hive/HiveJDBCInterface" by BillGraham
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".
+
+