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". + +
