Hitachi Vantara Pentaho Community Wiki
Child pages
  • Reporting on Hive Data

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin
Wiki Markup


How to create a report that sources data from Hive.


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


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


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.

Include Page
Include Create Hive Report
Include Create Hive Report
Wiki Markup