Getting Started with Hive E-Learning

Order this unique E-Learning course Getting Started with Hive online, 1 year 24/7 access to rich interactive videos, speech, progress monitoring through reports and tests per chapter to test the knowledge directly.

Hive is a data warehouse tool built on top of Hadoop. It allows users to analyze big data distributed in a cluster using a SQL-like query language. In this path, we cover the fundamentals of data warehouses with a specific focus on Hive. We explore how Hive queries are translated to Hadoop MapReduce jobs under the hood and cover the features of Hive that make it so popular in the field of data analytics. This path also covers Hive basics such as creating, populating, and querying tables and also includes more advanced topics such as optimizing query executions using partitioning and bucketing.

Course content

Getting Started with Hive: Introduction

Course: 56 Minutes

• Course Overview
• Hive as a Data Warehouse
• Overview of Relational Databases
• OLTP and OLAP
• Hive and the Hadoop Ecosystem
• HiveServer and The Metastore
• Hive on Cloud Computing Platforms
• Data Types in Hive
• Data and Tables in Hive
• Exercise: Introduction to Hive

Getting Started with Hive: Loading and Querying Data

Course: 1 Hour, 20 Minutes

• Course Overview
• Setting up a Hadoop Cluster on the Google Cloud
• Creating a Hive Table
• Running Simple Queries in Hive
• Executing Hive Queries from the Shell
• Joining Tables in Hive
• Exploring the Hive Warehouse
• External Tables in Hive
• Modifying Tables in Hive
• Temporary Tables in Hive
• Loading Data into Tables in Hive
• Populating Multiple Tables in Hive
• Exercise: Loading and Querying Data in Hive

Getting Started with Hive: Viewing and Querying Complex Data

Course: 1 Hour, 14 Minutes

• Course Overview
• The Array Data Type in Hive
• The Map Data Type in Hive
• The Struct Type in Hive
• The explode and posexplode Functions in Hive
• Lateral Views in Hive
• Multiple Lateral Views in Hive
• Set Operations in Hive
• The IN and EXISTS clauses in Hive
• Creating and Populating Tables in Hive
• Views in Hive
• Exercise: Viewing and Querying Complex Data

Getting Started with Hive: Optimizing Query Executions

Course: 43 Minutes

• Course Overview
• Hive Queries as MapReduce Jobs
• Techniques to Improve Query Performance in Hive
• Partitioning Tables in Hive
• Bucketing Tables in Hive
• Structuring Join Queries in Hive
• Exercise: Optimizing Query Execution in Hive

Getting Started with Hive: Optimizing Query Executions with Partitioning

Course: 1 Hour, 1 Minute

• Course Overview
• Setting up a Hadoop Cluster on the Google Cloud
• Creating a Partitioned Table in Hive
• Working with Partitions in Hive
• Populating Partitions in Hive
• Partitioning External Tables in Hive
• Modifying Partitions in Hive
• Dynamic Partitions in Hive
• Using Multiple Columns for Partitioning in Hive
• Exercise: Optimize Executions with Partitioning

Getting Started with Hive: Bucketing & Window Functions

Course: 1 Hour, 4 Minutes

• Course Overview
• Apply Bucketing for a Table in Hive
• Using Bucketing and Partitioning Together in Hive
• Sorting a Bucket's Contents in Hive
• Sampling a Table in Hive
• Joining Multiple Tables in Hive
• Introducing Window Functions in Hive
• Windows Functions with Partitions in Hive
• Exercise: Bucketing and Window Functions in Hive