Analyzing Big Data with Hive

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