Hive makes Hadoop accessible to users who already know SQL, and Sqoop enables you to automatically import data from existing RDBMS sources.

Cloudera's one-day course on Hive and Sqoop is designed for Hive users and Developers with a basic understanding of how Hadoop works. Cloudera's one-day Introduction to Hadoop course provides all the necessary background required.

Please note, Hive and Sqoop are under active development, and may offer additional functionality by the time of this session. In that case, we may modify the below agenda to include the most relevant information available at the time.

We'll alternate between instructional sessions and hands-on labs to ensure participants leave ready to import and analyze their own data with Hive.

We'll cover the following topics:

• Intro to Hive
  • What is Hive/Hadoop?
• Getting data into Hive
  
  • Creating tables
  • Data types
  • Load data
  • SerDe
  • External tables
  • Importing and Exporting Data between HDFS and RDBMS with Sqoop
  • Hands-on Exercise: loading data into Hive
• Hive Architecture
  • Hive interfaces
  • Hive architecture
  • The Hive CLI
• HiveQL
  • SQL vs. HiveQL
  • SELECT
  • Functions
  • GROUP BY
  • Custom map/reduce scripts
  • Subqueries
  • Joins
  • Inserting
  • Hands-on Exercise: Writing queries in HiveQL
• Query Execution
  • Types of query plans
  • EXPLAIN
  • Join execution
  • Using hints
  • Hands-on Exercise: EXPLAIN
• Partitioning and Bucketing
  • Creating partitions
  • Loading data into partitions
  • Bucketing
  • Sampling
  • Hands-on Exercise: Using partitioning and bucketing
• Best Practices
  • Configuring Hive
  • Hive's metastore
  • Handling data in Hive
  • Other recommendations
• Troubleshooting
  • The JobTracker UI
  • Logging
  • Problems with Derby
  • Using the mailing list