-
Lesson 1 - Apache Hive in the Hadoop Ecosystem
-
Lesson 2 - Create and Load Data in Apache Hive
-
Lesson 3 - Query Data in Apache Hive
- Course Materials
-
Lab Guide
-
Hive Lab Files
Query and Store Data with Apache Hive
Review of SQL-on-Hadoop tools. Learn to create, load, query, and manipulate tables, and use Hive Query Language to query structured data without writing MapReduce code.
This course begins with a review of SQL-on-Hadoop tools, then covers how to create, load, query, and manipulate tables in Hive. You will learn how to use Hive to query structured data without writing MapReduce code. You will learn how Apache Hive fits in the Hadoop ecosystem, how to create and load tables in Hive, and how to query data using the Hive Query Language. Together with DA 450 - Transform Data with Apache Pig, you can learn how to use Pig and Hive as part of a single data flow in a Hadoop cluster.
What's Covered
| Course Lessons | Lab Activities |
|
1: Hive in the Hadoop Ecosystem Hive Use CasesSteps in the Data Pipeline Hive in the Hadoop Ecosystem Data Types Use With Hive |
Connect to the Hive CLI Cast Data |
|
2: Create and Load Data About Physical Query PlansCreate Databases and Internal Tables Create External Tables and Partitioned Tables Load Data Into Tables and Databases Alter and Drop Tables |
Create a Database Create a Simple Table Create Partitioned and External Tables Load Data Into Tables Examine Databases and Tables |
|
3: Query and Store Data Query, Sort, and Filter DataManipulate Data With User-defined Functions Combine and Store Tables |
Query Data With SELECT Query Data With UDFs Combine and Store Data |
Prerequisites
- Linux skills, including familiarity with command-line options such as ls, cd, cp, and su
- Beginning to intermediate proficiency with SQL
- Basic Hadoop knowledge