Right Outer Join

13 February 2012

Hadoop Hive and iReport

Filed under: JasperReports — Tags: , , , — mdahlman @ 11:09

Hadoop Hive and iReport

In articles that I write, I tend to focus on Jaspersoft technologies. I leave it as an exercise for the reader to figure out how to manage the backend data source whether it’s an XML file or a relational database or a big data solution like Hadoop.

I just came across an article with some really useful tips about configuring Hadoop Hive and then connecting to it from iReport. After configuring Hive, it then shows an interesting query example using exploding lateral views(!!). Don’t worry, the article explains what the lateral view HiveQL syntax means. It’s a great big picture view of getting Hadoop configured well and then performing reporting or analysis tasks on it.

Take a look at this short tutorial covering Hadoop Hive configuration and iReport. Maybe someday soon they add the next step of performing more Ad Hoc analysis using JasperReports Server as well.



  1. i am getting some unusual error in hive
    Hive is running fine untill and unless hadoop-hive connection established in ireport
    once i connect to ireport,,i am not able to do anything with hive.at a time i am able to run only one either ireport or hive command line interface
    this is the error i am getting.

    hive> show databases;
    FAILED: Error in metadata: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient
    FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask

    Comment by Shankar Panda — 22 January 2013 @ 03:00

    • Shankar,
      Please post this as a question to the Jaspersoft forums. My first guess is that it’s due to the use of Derby for the Hive Metastore. So please add some details around your configuration when you post.
      Thanks for reading,

      Comment by mdahlman — 22 January 2013 @ 09:01

RSS feed for comments on this post. TrackBack URI

Go on... leave a reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: