Cloudera Data Analyst Training

Using Pig, Hive, and Impala with Hadoop

Cloudera University’s four-day data analyst course is for anyone who wants to access, manipulate, transform, and analyze massive data sets in the Hadoop cluster using SQL and familiar scripting languages. This is the core curriculum in the data analyst learning path.


 The professionalism and expansive technical knowledge demonstrated by our classroom instructor were incredible. The quality of Cloudera training was on par with a university. 

– General Dynamics

Find a Class Near You

Advance Your Ecosystem Expertise

Apache Pig applies the fundamentals of familiar scripting languages to the Hadoop cluster. Apache Hive makes transformation and analysis of complex, multi-structured data scalable in Hadoop. Cloudera Impala enables real-time interactive analysis of the data stored in Hadoop via a native SQL environment. Together, Pig, Hive, and Impala make multi-structured data accessible to analysts, database administrators, and others without Java programming expertise.

Hands-On Hadoop

Through instructor-led discussion and interactive, hands-on exercises, participants will navigate the Hadoop ecosystem, learning topics such as:

  • The features that Pig, Hive, and Impala offer for data acquisition, storage, and analysis
  • The fundamentals of Apache Hadoop and data ETL (extract, transform, load), ingestion, and processing with Hadoop
  • How Pig, Hive, and Impala improve productivity for typical analysis tasks
  • Joining diverse datasets to gain valuable business insight
  • Performing real-time, complex queries on datasets

Course Overview »

Audience & Prerequisites

This course is designed for data analysts, business intelligence specialists, developers, system architects, and database administrators. Knowledge of SQL is assumed, as is basic Linux command-line familiarity. Knowledge of at least one scripting language (e.g., Bash scripting, Perl, Python, Ruby) would be helpful but is not essential. Prior knowledge of Apache Hadoop is not required.

Data Scientist Certification

Data Analyst Training is a useful precursor to Introduction to Data Science and the Cloudera Certified Professional: Data Scientist (CCP:DS) exam. Certification is a great differentiator; it helps establish you as a leader in the field, providing employers and customers with tangible evidence of your skills and expertise.

Get Certified »

Private Training

We also provide private training at your site, at your pace, and tailored to your needs.

Onsite Request »

Advance Your Career

Big data analysts are among the world's most in-demand and highly-compensated technical roles. Check out some of the job opportunities currently listed that match the professional profile, many of which seek experience with Impala, Hive, and Pig.

Job Opportunities »

Meet the Instructor: Nathan Neff

Over time, Hadoop will enable the collection of all the information stored in the cells and behaviors of every living thing on Earth, which could have amazing implications.

Meet Nate »

Meet the Instructor: Glynn Durham

Hadoop is clearly an important platform that helps users succeed in more ways with more data. But let’s be clear: it’s the data that’s most important.

Meet Glynn »