Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Analyzing Big Data with Hive

via LinkedIn Learning

Overview

Learn how to use Hive to analyze large datasets and derive information from Hadoop. Learn how to work with tables, structures, aggregations, clauses, functions, and more.

Syllabus

Introduction
  • Welcome
  • What you should know before watching this course
  • Using the exercise files
1. Hive Concepts and Setup
  • Why use Hive
  • How Hive works
  • Setting up our demo environment
2. Working with Data in Hive
  • Understanding table structures in Hive
  • Creating tables in Hive
  • Handling CSV files in Hive
  • Partitioning tables
3. Retrieving Data from Hive
  • Simple SELECT statement
  • Retrieving data from complex structures
4. Aggregating Data
  • Simple aggregations
  • Enhanced aggregations with grouping sets
  • Using CUBE and ROLLUP
5. Filtering Results
  • Simple filter with the WHERE clause
  • Filtering aggregates with HAVING clause
  • Finding similar values with LIKE
6. Joining Tables
  • Combining tables with JOIN
  • When to use SEMI JOIN
  • Joining multiple tables together
7. Manipulating Data
  • Types of data manipulation functions
  • String functions
  • Math functions
  • Date functions
  • Conditional functions
Conclusion
  • Next steps

Taught by

Ben Sullins

Reviews

4.6 rating at LinkedIn Learning based on 298 ratings

Start your review of Analyzing Big Data with Hive

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.