{"id":930,"date":"2012-02-11T16:37:00","date_gmt":"2012-02-11T16:37:00","guid":{"rendered":"http:\/\/www.javacodegeeks.com\/2012\/10\/big-data-analytics-with-hive-and-ireport.html"},"modified":"2012-10-26T08:21:22","modified_gmt":"2012-10-26T08:21:22","slug":"big-data-analytics-with-hive-and","status":"publish","type":"post","link":"https:\/\/www.javacodegeeks.com\/2012\/02\/big-data-analytics-with-hive-and.html","title":{"rendered":"Big Data analytics with Hive and iReport"},"content":{"rendered":"
Each J.J. Abrams’ TV series Person of Interest<\/i><\/a> episode starts with the following narration from Mr. Finch one of the leading characters: \u201cYou are being watched. The government has a secret system–a machine that spies on you every hour of every day. I know because…I built it.<\/i>\u201d Of course us technical people know better. It would take a huge team of electrical and software engineers many years to build such a high performing machine and the budget would be unimaginable… or wouldn’t be? Wait a second we have Hadoop<\/a>! Now everyone of us can be Mr. Finch for a modest budget thanks to Hadoop<\/a>.<\/p>\n

In JCG article “Hadoop Modes Explained – Standalone, Pseudo Distributed, Distributed<\/a>\u201d JCG partner Rahul Patodi explained how to setup Hadoop<\/a>. The Hadoop <\/a>project has produced a lot of tools for analyzing semi-structured data but Hive<\/a> is perhaps the most intuitive among them as it allows anyone with an SQL background to submit MapReduce jobs described as SQL queries. Hive<\/a> can be executed from a command line interface, as well as run in a server mode with a Thrift<\/a> client acting as a JDBC\/ODBC interface giving access to data analysis and reporting applications.<\/p>\n

In this article we will set up a Hive<\/a> Server, create a table, load it with data from a text file and then create a Jasper Resport using iReport<\/a>. The Jasper Report executes an SQL query on the Hive<\/a> Server that is then translated to a MapReduce job executed by Hadoop<\/a>.<\/p>\n

Note: I used Hadoop version 0.20.205, Hive version 0.7.1 and iReport version 4.5 running OpenSuSE 12.1 Linux with MySQL<\/a> 5.5 installed.<\/p>\n

Assuming you have already installed Hadoop<\/a> download and install Hive<\/a> following the Hive<\/a> Getting Started<\/a> wiki instructions. By default Hive<\/a> is installed in CLI mode running on a Standalone Hadoop<\/a> mode.<\/p>\n

Making a multiuser Hive metastore<\/strong><\/p>\n

The default Hive install uses a derby embedded database as its metastore. The metastore is where Hive maintains descriptions of the data we want to access via SQL. In order for the metastore to be accessible from many users simultaneously it is necessary to be moved into a standalone database. Here is how to install a MySQL metastore.<\/p>\n

    \n
  1. Copy the MySQL JDBC driver<\/a> jar file to ~\/hive-0.7.1-bin\/lib<\/i> directory\n<\/li>\n
  2. Change the following properties in file hive-default.xml<\/i> found in ~\/hive-0.7.1-bin\/conf<\/i> directory:\n
    <property>\r\n  <name>javax.jdo.option.ConnectionURL<\/name>\r\n  <value>jdbc:mysql:\/\/hyperion\/metastore?createDatabaseIfNotExist=true<\/value>\r\n  <description>JDBC connect string for a JDBC metastore<\/description>\r\n<\/property>\r\n\r\n<property>\r\n  <name>javax.jdo.option.ConnectionDriverName<\/name>\r\n  <value>com.mysql.jdbc.Driver<\/value>\r\n  <description>Driver class name for a JDBC metastore<\/description>\r\n<\/property>\r\n\r\n<property>\r\n  <name>javax.jdo.option.ConnectionUserName<\/name>\r\n  <value>foo<\/value>\r\n  <description>Username to connect to the database<\/description>\r\n<\/property>\r\n\r\n<property>\r\n  <name>javax.jdo.option.ConnectionPassword<\/name>\r\n  <value>bar<\/value>\r\n  <description>Password to connect to the database<\/description>\r\n<\/property>\r\n<\/pre>\n<\/li>\n
  3. Use MySQL workbench or the MySQL command line utility to create a schema using the latin1 character set. If Hive does not find a schema it will create it on its own using the default character set for MySQL.  In my case that was UTF-8 and that generated jdbc errors.  If you want to use the command line utility just type:\n
    mysql> CREATE DATABASE  IF NOT EXISTS `metastore` DEFAULT CHARACTER SET latin1 COLLATE latin1_bin;\r\n<\/pre>\n<\/li>\n
  4. Type Hive in your command prompt to enter Hive CLI and type:\n
    hive> SHOW TABLES;\r\nOK\r\ntestlines\r\nTime taken: 3.654 seconds\r\nhive> \r\n<\/pre>\n
    That will populate your newly created metastore schema.  If you see any errors check your hive-default.xml<\/i> configuration and make sure your database schema is named ‘metastore’ with latin1 as the default Character Set.\n<\/li>\n<\/ol>\n

    \n<\/strong>
    \nNow let’s populate Hadoop Hive with some data<\/strong>
     
    <\/div> <\/div><\/p>\n
    Let’s just create two text files named file01 <\/i><\/strong>and file02 <\/i><\/strong>each containing:<\/p>\n
    file01<\/i>:<\/strong>
    \nHello World Bye World
    \nHello Everybody Bye Everybody<\/p>\n
    file02<\/i>:<\/strong>
    \nHello Hadoop Goodbye Hadoop
    \nHello Everybody Goodbye Everybody<\/p>\n
    Copy these files from your local filesystem to HDFS:<\/p>\n
    $ hadoop fs -mkdir HiveExample\r\n$ hadoop fs -copyFromLocal ~\/file* \/user\/ssake\/HiveExample\r\n<\/pre>\n
    Go to Hive CLI and create a table named testlines that would contain each line’s words in an array of strings:<\/p>\n
    hive> create table testlines (line array<string>) row format delimited collection items terminated by ' ';\r\n<\/pre>\n
    Load the text files into Hive:<\/p>\n
    hive> load data inpath \"\/user\/ssake\/HiveExample\/file01\" INTO table testlines;\r\nhive> load data inpath \"\/user\/ssake\/HiveExample\/file02\" INTO table testlines;\r\n<\/pre>\n
    Check that testlines now contains each line’s words:<\/p>\n
    hive> select * from testlines;\r\nOK\r\n[\"Hello\",\"World\",\"Bye\",\"World\"]\r\n[\"Hello\",\"Everybody\",\"Bye\",\"Everybody\"]\r\n[\"Hello\",\"Hadoop\",\"Goodbye\",\"Hadoop\"]\r\n[\"Hello\",\"Everybody\",\"Goodbye\",\"Everybody\"]\r\nTime taken: 0.21 seconds\r\n<\/pre>\n
    Now that we have a Hive with data we can run it as a server in port 10000 which is typical for running a hive server:<\/p>\n
    $ HIVE_PORT=10000\r\n$ hive --service hiveserver \r\n<\/pre>\n
    With this setup it is possible to have several Thrift clients accessing our Hive server.  However according to the Apache Hive blog<\/a> the multithreaded Hive features are not thoroughly tested and thus it is safer to use a separate port and hive instance per Thrift client.<\/p>\n
    Create a “word count” report<\/strong><\/p>\n
    iReport 4.5<\/a> supports hive datasources so let’s use it to create a report that runs with our hive server as its datasource:<\/p>\n
    1. Create a datasource connecting to the hive server<\/p>\n
    <\/a><\/div>\n
    2. Use the report wizard to generate your report<\/p>\n
    <\/a><\/div>\n
    3. Type the following in the HiveQL<\/a> Query input box:<\/p>\n
    select word,count(word) from testlines lateral view explode(line) words as word group by word\r\n<\/pre>\n
    Lets briefly explain what the above query does:<\/p>\n
    Our source table, the “testlines” table, has a single column named “line” which contains data in the form of array of strings. Each array of strings represents the words in a sentence as found in the imported files “file01<\/i><\/strong>” and “file02<\/i><\/strong>“.<\/p>\n
    In order to properly count the occurrences of each distinct word in all of the input files we have to “explode” the arrays of strings from our source table into a new one that should contain every individual word. To do so we use the “lateral view” in conjunction with the “explode()” HiveQL<\/a> commands as shown above.<\/p>\n
    Issuing the HiveQL<\/a> query above we create an new iconic table named “words” that has a single column named “word” containing all the words found in every string array from our “testlines” table.<\/p>\n
    <\/a><\/div>\n
    4. Click the \u2026 button to select all fileds and click next<\/p>\n
    <\/a><\/div>\n
    5. When you are at the designer view click the Preview tab to execute your HiveQL report<\/p>\n
    <\/a><\/div>\n
    And here is our report:<\/p>\n
    <\/a><\/div>\n
    Now you are all set to build applications that access your Hadoop data using the familiar JDBC interface!<\/p>\n
    Reference: <\/i><\/strong>Big Data analytics with Hive and iReport<\/i> from our W4G partner<\/a> Spyros Sakellariou<\/a>.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
    Each J.J. Abrams’ TV series Person of Interest episode starts with the following narration from Mr. Finch one of the leading characters: \u201cYou are being watched. The government has a secret system–a machine that spies on you every hour of every day. I know because…I built it.\u201d Of course us technical people know better. It …<\/p>\n","protected":false},"author":311,"featured_media":144,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[371,184,374,372,373,175,183,238,206],"class_list":["post-930","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-enterprise-java","tag-analytics","tag-apache-hadoop","tag-apache-hive","tag-big-data","tag-jaspersoft-ireport","tag-jaspersoft-jasperreports","tag-mapreduce","tag-spyros-sakellariou","tag-w4g"],"yoast_head":"\nBig Data analytics with Hive and iReport - Java Code Geeks<\/title>\n<meta name=\"description\" content=\"Each J.J. Abrams' TV series Person of Interest episode starts with the following narration from Mr. Finch one of the leading characters: \u201cYou are being\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.javacodegeeks.com\/2012\/02\/big-data-analytics-with-hive-and.html\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Big Data analytics with Hive and iReport - Java Code Geeks\" \/>\n<meta property=\"og:description\" content=\"Each J.J. Abrams' TV series Person of Interest episode starts with the following narration from Mr. Finch one of the leading characters: \u201cYou are being\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.javacodegeeks.com\/2012\/02\/big-data-analytics-with-hive-and.html\" \/>\n<meta property=\"og:site_name\" content=\"Java Code Geeks\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/javacodegeeks\" \/>\n<meta property=\"article:published_time\" content=\"2012-02-11T16:37:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2012-10-26T08:21:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2012\/10\/jaspersoft-ireport-logo.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"150\" \/>\n\t<meta property=\"og:image:height\" content=\"150\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Spyros Sakellariou\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@javacodegeeks\" \/>\n<meta name=\"twitter:site\" content=\"@javacodegeeks\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Spyros Sakellariou\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2012\\\/02\\\/big-data-analytics-with-hive-and.html#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2012\\\/02\\\/big-data-analytics-with-hive-and.html\"},\"author\":{\"name\":\"Spyros Sakellariou\",\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/#\\\/schema\\\/person\\\/720cbce6bf34368577bca92d044827f9\"},\"headline\":\"Big Data analytics with Hive and iReport\",\"datePublished\":\"2012-02-11T16:37:00+00:00\",\"dateModified\":\"2012-10-26T08:21:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2012\\\/02\\\/big-data-analytics-with-hive-and.html\"},\"wordCount\":915,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2012\\\/02\\\/big-data-analytics-with-hive-and.html#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.javacodegeeks.com\\\/wp-content\\\/uploads\\\/2012\\\/10\\\/jaspersoft-ireport-logo.jpg\",\"keywords\":[\"Analytics\",\"Apache Hadoop\",\"Apache Hive\",\"Big Data\",\"Jaspersoft iReport\",\"Jaspersoft JasperReports\",\"MapReduce\",\"Spyros Sakellariou\",\"W4G\"],\"articleSection\":[\"Enterprise Java\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.javacodegeeks.com\\\/2012\\\/02\\\/big-data-analytics-with-hive-and.html#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2012\\\/02\\\/big-data-analytics-with-hive-and.html\",\"url\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2012\\\/02\\\/big-data-analytics-with-hive-and.html\",\"name\":\"Big Data analytics with Hive and iReport - Java Code Geeks\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2012\\\/02\\\/big-data-analytics-with-hive-and.html#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2012\\\/02\\\/big-data-analytics-with-hive-and.html#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.javacodegeeks.com\\\/wp-content\\\/uploads\\\/2012\\\/10\\\/jaspersoft-ireport-logo.jpg\",\"datePublished\":\"2012-02-11T16:37:00+00:00\",\"dateModified\":\"2012-10-26T08:21:22+00:00\",\"description\":\"Each J.J. Abrams' TV series Person of Interest episode starts with the following narration from Mr. Finch one of the leading characters: \u201cYou are being\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2012\\\/02\\\/big-data-analytics-with-hive-and.html#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.javacodegeeks.com\\\/2012\\\/02\\\/big-data-analytics-with-hive-and.html\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2012\\\/02\\\/big-data-analytics-with-hive-and.html#primaryimage\",\"url\":\"https:\\\/\\\/www.javacodegeeks.com\\\/wp-content\\\/uploads\\\/2012\\\/10\\\/jaspersoft-ireport-logo.jpg\",\"contentUrl\":\"https:\\\/\\\/www.javacodegeeks.com\\\/wp-content\\\/uploads\\\/2012\\\/10\\\/jaspersoft-ireport-logo.jpg\",\"width\":150,\"height\":150},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/2012\\\/02\\\/big-data-analytics-with-hive-and.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.javacodegeeks.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Java\",\"item\":\"https:\\\/\\\/www.javacodegeeks.com\\\/category\\\/java\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Enterprise Java\",\"item\":\"https:\\\/\\\/www.javacodegeeks.com\\\/category\\\/java\\\/enterprise-java\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Big Data analytics with Hive and iReport\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/#website\",\"url\":\"https:\\\/\\\/www.javacodegeeks.com\\\/\",\"name\":\"Java Code Geeks\",\"description\":\"Java Developers Resource Center\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/#organization\"},\"alternateName\":\"JCG\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.javacodegeeks.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/#organization\",\"name\":\"Exelixis Media P.C.\",\"url\":\"https:\\\/\\\/www.javacodegeeks.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.javacodegeeks.com\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/exelixis-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.javacodegeeks.com\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/exelixis-logo.png\",\"width\":864,\"height\":246,\"caption\":\"Exelixis Media P.C.\"},\"image\":{\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/javacodegeeks\",\"https:\\\/\\\/x.com\\\/javacodegeeks\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.javacodegeeks.com\\\/#\\\/schema\\\/person\\\/720cbce6bf34368577bca92d044827f9\",\"name\":\"Spyros Sakellariou\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1f277f6c18ec3de65081d1f237635a466a0029a8faa53d054a404c94c0c3ee15?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1f277f6c18ec3de65081d1f237635a466a0029a8faa53d054a404c94c0c3ee15?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1f277f6c18ec3de65081d1f237635a466a0029a8faa53d054a404c94c0c3ee15?s=96&d=mm&r=g\",\"caption\":\"Spyros Sakellariou\"},\"url\":\"https:\\\/\\\/www.javacodegeeks.com\\\/author\\\/spyros-sakellariou\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Big Data analytics with Hive and iReport - Java Code Geeks","description":"Each J.J. Abrams' TV series Person of Interest episode starts with the following narration from Mr. Finch one of the leading characters: \u201cYou are being","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.javacodegeeks.com\/2012\/02\/big-data-analytics-with-hive-and.html","og_locale":"en_US","og_type":"article","og_title":"Big Data analytics with Hive and iReport - Java Code Geeks","og_description":"Each J.J. Abrams' TV series Person of Interest episode starts with the following narration from Mr. Finch one of the leading characters: \u201cYou are being","og_url":"https:\/\/www.javacodegeeks.com\/2012\/02\/big-data-analytics-with-hive-and.html","og_site_name":"Java Code Geeks","article_publisher":"https:\/\/www.facebook.com\/javacodegeeks","article_published_time":"2012-02-11T16:37:00+00:00","article_modified_time":"2012-10-26T08:21:22+00:00","og_image":[{"width":150,"height":150,"url":"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2012\/10\/jaspersoft-ireport-logo.jpg","type":"image\/jpeg"}],"author":"Spyros Sakellariou","twitter_card":"summary_large_image","twitter_creator":"@javacodegeeks","twitter_site":"@javacodegeeks","twitter_misc":{"Written by":"Spyros Sakellariou","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.javacodegeeks.com\/2012\/02\/big-data-analytics-with-hive-and.html#article","isPartOf":{"@id":"https:\/\/www.javacodegeeks.com\/2012\/02\/big-data-analytics-with-hive-and.html"},"author":{"name":"Spyros Sakellariou","@id":"https:\/\/www.javacodegeeks.com\/#\/schema\/person\/720cbce6bf34368577bca92d044827f9"},"headline":"Big Data analytics with Hive and iReport","datePublished":"2012-02-11T16:37:00+00:00","dateModified":"2012-10-26T08:21:22+00:00","mainEntityOfPage":{"@id":"https:\/\/www.javacodegeeks.com\/2012\/02\/big-data-analytics-with-hive-and.html"},"wordCount":915,"commentCount":1,"publisher":{"@id":"https:\/\/www.javacodegeeks.com\/#organization"},"image":{"@id":"https:\/\/www.javacodegeeks.com\/2012\/02\/big-data-analytics-with-hive-and.html#primaryimage"},"thumbnailUrl":"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2012\/10\/jaspersoft-ireport-logo.jpg","keywords":["Analytics","Apache Hadoop","Apache Hive","Big Data","Jaspersoft iReport","Jaspersoft JasperReports","MapReduce","Spyros Sakellariou","W4G"],"articleSection":["Enterprise Java"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.javacodegeeks.com\/2012\/02\/big-data-analytics-with-hive-and.html#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.javacodegeeks.com\/2012\/02\/big-data-analytics-with-hive-and.html","url":"https:\/\/www.javacodegeeks.com\/2012\/02\/big-data-analytics-with-hive-and.html","name":"Big Data analytics with Hive and iReport - Java Code Geeks","isPartOf":{"@id":"https:\/\/www.javacodegeeks.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.javacodegeeks.com\/2012\/02\/big-data-analytics-with-hive-and.html#primaryimage"},"image":{"@id":"https:\/\/www.javacodegeeks.com\/2012\/02\/big-data-analytics-with-hive-and.html#primaryimage"},"thumbnailUrl":"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2012\/10\/jaspersoft-ireport-logo.jpg","datePublished":"2012-02-11T16:37:00+00:00","dateModified":"2012-10-26T08:21:22+00:00","description":"Each J.J. Abrams' TV series Person of Interest episode starts with the following narration from Mr. Finch one of the leading characters: \u201cYou are being","breadcrumb":{"@id":"https:\/\/www.javacodegeeks.com\/2012\/02\/big-data-analytics-with-hive-and.html#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.javacodegeeks.com\/2012\/02\/big-data-analytics-with-hive-and.html"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.javacodegeeks.com\/2012\/02\/big-data-analytics-with-hive-and.html#primaryimage","url":"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2012\/10\/jaspersoft-ireport-logo.jpg","contentUrl":"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2012\/10\/jaspersoft-ireport-logo.jpg","width":150,"height":150},{"@type":"BreadcrumbList","@id":"https:\/\/www.javacodegeeks.com\/2012\/02\/big-data-analytics-with-hive-and.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.javacodegeeks.com\/"},{"@type":"ListItem","position":2,"name":"Java","item":"https:\/\/www.javacodegeeks.com\/category\/java"},{"@type":"ListItem","position":3,"name":"Enterprise Java","item":"https:\/\/www.javacodegeeks.com\/category\/java\/enterprise-java"},{"@type":"ListItem","position":4,"name":"Big Data analytics with Hive and iReport"}]},{"@type":"WebSite","@id":"https:\/\/www.javacodegeeks.com\/#website","url":"https:\/\/www.javacodegeeks.com\/","name":"Java Code Geeks","description":"Java Developers Resource Center","publisher":{"@id":"https:\/\/www.javacodegeeks.com\/#organization"},"alternateName":"JCG","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.javacodegeeks.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.javacodegeeks.com\/#organization","name":"Exelixis Media P.C.","url":"https:\/\/www.javacodegeeks.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.javacodegeeks.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png","contentUrl":"https:\/\/www.javacodegeeks.com\/wp-content\/uploads\/2022\/06\/exelixis-logo.png","width":864,"height":246,"caption":"Exelixis Media P.C."},"image":{"@id":"https:\/\/www.javacodegeeks.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/javacodegeeks","https:\/\/x.com\/javacodegeeks"]},{"@type":"Person","@id":"https:\/\/www.javacodegeeks.com\/#\/schema\/person\/720cbce6bf34368577bca92d044827f9","name":"Spyros Sakellariou","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1f277f6c18ec3de65081d1f237635a466a0029a8faa53d054a404c94c0c3ee15?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1f277f6c18ec3de65081d1f237635a466a0029a8faa53d054a404c94c0c3ee15?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1f277f6c18ec3de65081d1f237635a466a0029a8faa53d054a404c94c0c3ee15?s=96&d=mm&r=g","caption":"Spyros Sakellariou"},"url":"https:\/\/www.javacodegeeks.com\/author\/spyros-sakellariou"}]}},"_links":{"self":[{"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/posts\/930","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/users\/311"}],"replies":[{"embeddable":true,"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/comments?post=930"}],"version-history":[{"count":0,"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/posts\/930\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/media\/144"}],"wp:attachment":[{"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/media?parent=930"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/categories?post=930"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.javacodegeeks.com\/wp-json\/wp\/v2\/tags?post=930"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}