Query and Store Data with Apache Hive

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.

About this Course

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 Cases
Steps 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 Plans
Create 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 Data
Manipulate 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

Curriculum

  • 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

About this Course

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 Cases
Steps 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 Plans
Create 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 Data
Manipulate 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

Curriculum

  • 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

For more information on how HPE manages, uses and protects your information please refer to HPE Privacy Statement. You can always withdraw or modify your consent to receive marketing communication from HPE. This can be done by using the opt-out and preference mechanism at the bottom of our email marketing communication or by following this link.

×