Book Image

Pentaho for Big Data Analytics

By : Manoj R Patil, Feris Thia
Book Image

Pentaho for Big Data Analytics

By: Manoj R Patil, Feris Thia

Overview of this book

<p>Pentaho accelerates the realization of value from big data with the most complete solution for big data analytics and data integration. The real power of big data analytics is the abstraction between data and analytics. Data can be distributed across the cluster in various formats, and the analytics platform should have the capability to talk to different heterogeneous data stores and fetch the filtered data to enrich its value.<br /><br />Pentaho Big Data Analytics is a practical, hands-on guide that provides you with clear, step-by-step exercises for using Pentaho to take advantage of big data systems, where data beats algorithm, and gives you a good grounding in using Pentaho Business Analytics’ capabilities.<br /><br />This book looks at the key ingredients of the Pentaho Business Analytics platform. We will see how to prepare the Pentaho BI environment, and get to grips with the big data ecosystem through. The book provides a clear guide to the essential tools of Pentaho Business Analytics, providing familiarity with both the various design tools for setting up reports, and the visualization tools necessary for complete data analysis.</p>
Table of Contents (14 chapters)
Pentaho for Big Data Analytics
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

Preparing data


Pentaho Data Integration (PDI) is a great tool to prepare data thanks to its rich data connectors. We will not discuss PDI further here as we already discussed it in the latter part of Chapter 3, Churning Big Data with Pentaho.

Preparing BI Server to work with Hive

Before you proceed to the following examples, complete the steps listed in Appendix B, Hadoop Setup. Note that all the remaining examples work with the 192.168.1.122 IP address configuration at Hortonworks Sandbox VM.

The following steps will help you prepare BI Server to work with Hive:

  1. Copy the pentaho-hadoop-hive-jdbc-shim-1.3-SNAPSHOT.jar and pentaho-hadoop-shims-api-1.3-SNAPSHOT.jar files into the [BISERVER]/administration-console/jdbc and [BISERVER]/biserver-ce/tomcat/lib folders respectively. See Chapter 3, Churning Big Data with Pentaho, for information on how to obtain the JAR files.

  2. Launch Pentaho User Console (PUC).

  3. Copy the Chapter 4 folder from the book's code bundle folder into [BISERVER]/pentaho-solutions...