Hive for Data Analysts

Hive for Data Analysts

This course is designed to help you understand how Hive integrates with Qubole to provide your team with fast, inexpensive and scalable data processing.

ABOUT THIS COURSE

LEARNING FORMAT:

Self-paced

DESCRIPTION:

This course is designed to give you an understanding of Hive Commands and Tuning concepts that will help optimize your query results.

Estimated time to complete this course: 30 mins.

Recommended Prerequisites:

Hive Commands

In this lesson you’ll learn about Hive Command structures that can help optimize your queries. Topics include:

 

  • Introduction to Hive
  • Map/Reduce Tasks & SQL
  • Hive Metadata
  • Partioning Data
  • The HiveQL Syntax
  • ORDER BY, SORT BY, DISTRIBUTE BY & CLUSTER BY Clauses
  • Hive Notebooks
  • Map & Outer Joins

Hive Tuning

In this lesson you’ll learn about opportunities for tuning Hive to benefit your query results. Topics include:

  • Managing Reducers
  • Reducer Optimization
  • The Tez Solution
  • DAG Analysis

Recommended Follow Up:

 

Curriculum

  • Course Introduction
  • Course Terminology
  • Hive Introduction
  • HiveQL Best Practices
  • Hive Notebooks
  • Basic Hive Tuning
  • Tez DAG Analysis
  • Course Conclusion

ABOUT THIS COURSE

LEARNING FORMAT:

Self-paced

DESCRIPTION:

This course is designed to give you an understanding of Hive Commands and Tuning concepts that will help optimize your query results.

Estimated time to complete this course: 30 mins.

Recommended Prerequisites:

Hive Commands

In this lesson you’ll learn about Hive Command structures that can help optimize your queries. Topics include:

 

  • Introduction to Hive
  • Map/Reduce Tasks & SQL
  • Hive Metadata
  • Partioning Data
  • The HiveQL Syntax
  • ORDER BY, SORT BY, DISTRIBUTE BY & CLUSTER BY Clauses
  • Hive Notebooks
  • Map & Outer Joins

Hive Tuning

In this lesson you’ll learn about opportunities for tuning Hive to benefit your query results. Topics include:

  • Managing Reducers
  • Reducer Optimization
  • The Tez Solution
  • DAG Analysis

Recommended Follow Up:

 

Curriculum

  • Course Introduction
  • Course Terminology
  • Hive Introduction
  • HiveQL Best Practices
  • Hive Notebooks
  • Basic Hive Tuning
  • Tez DAG Analysis
  • Course Conclusion