About This Course

Writing MapReduce programs to analyze your Big Data can get complex. Hive can help make querying your data much easier. Apache Hive, first created at Facebook, is a data warehouse system for Hadoop that facilitates easy data summarization, ad-hoc queries, and the analysis of large datasets stored in Hadoop compatible file systems. Hive provides a mechanism to project structure onto this data and query the data using a SQL-like language called HiveQL. This course will get you started so that you can use Hive for Data Warehousing tasks on your Big Data projects.

What will I get after passing this course?

• You will receive a completion certificate.

Course Syllabus

• Lesson 1 - Introduction to Hive
• Describe what Hive is, what it’s used for and how it compares to other similar technologies
• Describe the Hive architecture
• Describe the main components of Hive
• List interesting ways others are using Hive
• Lesson 2 - Hive DDL
• Create databases and tables in Hive, while using a variety of different Data Types
• Run a variety of different DDL commands
• Use Partitioning to improve performance of Hive queries
• Create Managed and External tables in Hive
• Lesson 3 - Hive DML
• Load data into Hive
• Export data out of Hive
• Run a variety of different HiveQL DML queries
• Lesson 4 - Hive Operators and Functions
• Use a variety of Hive Operators in your queries
• Utilize Hive’s Built-in Functions
• Explain ways to extend Hive functionality

General information

1. This course is self-paced.
2. It can be taken at any time.
3. It can be taken as many times as you wish.