Jump to content
We've recently updated our Privacy Statement, available here ×

  • mdahlman
    • Version: v4.7, v4.5

    Jaspersoft's Hadoop-Hive Connector

    Works with iReport, JasperReports, and JasperReports Server

    Target Audience

    Users who want to integrate Jaspersoft's JasperReports Server with Hadoop using the Hive database. This document assumes that the user already has familiarity with Hadoop and Hive and already has data in Hadoop stored in Hive tables accessible using external JDBC connections.

    [toc]

    Background

    JasperReports Server 4.5 and iReport 4.5 include the HadoopHive connector. Users working with older versions of JasperReports Server or iReport should upgrade to 4.5 or later to get connectivity to Hadoop Hive. Using the Hive connector with older versions of iReport or JasperReports Server is possible. Please contact bigdata@jaspersoft.com for details.

    Tests were performed with Hive X.Y.Z on distributions from Apache, Cloudera (CDH3), and IBM (BigInsights). It's likely to work with other versions, but others are not tested.

    Summary

    1. Create a report in iReport using Hive data
    2. Deploy the report to JasperReports Server

    Details

    Create a report

    Create a new report; set the query language to "HiveQL". The query language for Hive. It is documented here: HiveQL

    Deploy the report to JasperReports Server

    1. Data Source
    2. : Define the data source in JasperReports Server
    3. : screenshots coming soon
    4. Report
    5. * Deploy the report from iReport
    6. : screenshots coming soon
    7. * Deploy the report from the JasperReports Server GUI
    8. : screenshots coming soon

    Related Links


    User Feedback

    Recommended Comments

    There are no comments to display.



    Create an account or sign in to comment

    You need to be a member in order to leave a comment

    Create an account

    Sign up for a new account in our community. It's easy!

    Register a new account

    Sign in

    Already have an account? Sign in here.

    Sign In Now

×
×
  • Create New...