{scrollbar}

How to create a report that sources data from Hive.

Prerequisites

In order follow along with this how-to guide you will need the following:

Hadoop
Pentaho Data Integration
Hive
Report Designer
RDBMS Database

Sample Files

The sample data file needed for this guide is:

File Name	Content
weblogs_hive.zip	Tab-delimited, aggregated weblog data for a Hive weblogs_agg table

NOTE: If you have already completed the Transforming Data within Hive guide, then the necessary Hive table, weblog_aggs, will already be created and populated.

Step-By-Step Instructions

Setup

Start Hadoop if it is not already running.
Start Hive Server if it is not already running.

Create a Hive Table

NOTE: This task may be skipped if you have completed Transforming Data within Hive guide.

{scrollbar}