Every registration supports local education. TrainUp Gives Back

Your Career Training Marketplace

Questions? Call Toll-Free: 1-866-540-9677

  • Instant Access ImageInstant Access
    From Anywhere
  • Unlimited Viewing ImageUnlimited
  • calendar Image 6-12 Months
    To Complete


Apache Hadoop is a set of algorithms for distributed storage and distributed processing of Big Data on computer clusters built from commodity hardware. All the modules in Hadoop are designed with a fundamental assumption that hardware failures are commonplace and thus should be automatically handled in software by the framework. In this course, you'll explore Hive as a SQL like tool for interfacing with Hadoop. The course demonstrates the installation and configuration of Hive, followed by demonstration of Hive in action. Finally, you'll learn about extracting and loading data between Hive and a RDBMS. This learning path can be used as part of the preparation for the Cloudera Certified Administrator for Apache Hadoop (CCA-500) exam.

Learning Objectives
  • Start the course
  • Recall the key attributes of Hive
  • Describe the configuration files
  • Install and configure Hive
  • Create a table in Derby using Hive
  • Create a table in MySQL using Hive
  • Recall the unique delimiter that Hive uses
  • Describe the different operators in Hive
  • Use basic SQL commands in Hive
  • Use SELECT statements in Hive
  • Use more complex HiveQL
  • Write and use Hive scripts
  • Recall what types of joins Hive can support
  • Use Hive to perform joins
  • Recall that a Hive partition schema must be created before loading the data
  • Write a Hive partition script
  • Recall how buckets are used to improve performance
  • Create Hive buckets
  • Recall some best practices for user defined functions
  • Create a user defined function for Hive
  • Recall the standard error code ranges and what they mean
  • Use a Hive explain plan
  • Understand configuration option, data loading and querying
  • Audience

Get the latest industry news, recommended courses, & promotions from TrainUp.com sent straight to your inbox.