We're offering 20% off September Live Online classes! See which courses are applicable.   |   Details >

AccountIcon BigDataIcon BlogIcon default_resource_icon CartIcon checkmark_icon cloud_devops_icon computer_network_admin_icon cyber_security_icon gsa_schedule_icon human_resources_icon location_icon phone_icon plus_icon programming_software_icon project_management_icon redhat_linux_icon search_icon sonography_icon sql_database_icon webinar_icon

Search UMBC Training Centers

Big Data Analytics

Hortonworks HDP Developer: Apache Pig and Hive

+ View more dates & times
  • Overview

    This course is designed for developers who need to create applications to analyze Big Data stored in Apache Hadoop using Pig and Hive. Topics include: Hadoop, YARN, HDFS, MapReduce, data ingestion, workflow definition, using Pig and Hive to perform data analytics on Big Data and an introduction to Spark Core and Spark SQL.

    Upon completion of this course, students will be able to:

    • Describe Hadoop, YARN and use cases for Hadoop
    • Describe Hadoop ecosystem tools and frameworks
    • Describe the HDFS architecture
    • Use the Hadoop client to input data into HDFS
    • Transfer data between Hadoop and a relational database
    • Explain YARN and MaoReduce architectures
    • Run a MapReduce job on YARN
    • Use Pig to explore and transform data in HDFS
    • Understand how Hive tables are defined and implemented
    • Use Hive to explore and analyze data sets
    • Use the new Hive windowing functions
    • Explain and use the various Hive file formats
    • Create and populate a Hive table that uses ORC file formats
    • Use Hive to run SQL-like queries to perform data analysis
    • Use Hive to join datasets using a variety of techniques
    • Write efficient Hive queries
    • Create ngrams and context ngrams using Hive
    • Perform data analytics using the DataFu Pig library
    • Explain the uses and purpose of HCatalog
    • Use HCatalog with Pig and Hive
    • Define and schedule an Oozie workflow
    • Present the Spark ecosystem and high-level architecture
    • Perform data analysis with Spark’s Resilient Distributed Dataset API
    • Explore Spark SQL and the DataFrame API
  • Who Should Take This Course


    This class is for Software developers who need to understand and develop applications for Hadoop.


    Students should be familiar with programming principles and have experience in software development. SQL knowledge is also helpful. No prior Hadoop knowledge is required.

  • Schedule
  • Course Outline

    Hands-On Labs

    1. Use HDFS commands to add/remove files and folders
    2. Use Sqoop to transfer data between HDFS and a RDBMS
    3. Run MapReduce and YARN application jobs
    4. Explore, transform, split and join datasets using Pig
    5. Use Pig to transform and export a dataset for use with Hive
    6. Use HCatLoader and HCatStorer
    7. Use Hive to discover useful information in a dataset
    8. Describe how Hive queries get executed as MapReduce jobs
    9. Perform a join of two datasets with Hive
    10. Use advanced Hive features: windowing, views, ORC files
    11. Use Hive analytics functions
    12. Write a custom reducer in Python
    13. Analyze clickstream data and compute quantiles with DataFu
    14. Use Hive to compute ngrams on Avro-formatted files
    15. Define an Oozie workflow
    16. Use Spark Core to read files and perform data analysis
    17. Create and join DataFrames with Spark SQL
  • FAQs
    Is there a discount available for current students?

    UMBC students and alumni, as well as students who have previously taken a public training course with UMBC Training Centers are eligible for a 10% discount, capped at $250. Please provide a copy of your UMBC student ID or an unofficial transcript or the name of the UMBC Training Centers course you have completed. Online courses are excluded from this offer.

    What is the cancellation and refund policy?

    Student will receive a refund of paid registration fees only if UMBC Training Centers receives a notice of cancellation at least 10 business days prior to the class start date for classes or the exam date for exams.

Contact Us