Writing Complex Analytical Queries with Hive

Hive is a data warehouse that runs on top of the Hadoop distributed computing framework. It works on huge datasets, so this course is useful for understanding its features so you can write efficient, fast, and optimal queries.
Course info
Rating
(45)
Level
Intermediate
Updated
Apr 25, 2017
Duration
3h 3m
Table of contents
Course Overview
Using Hive for Analytical Queries
Partitioning Tables for Faster Queries
Bucketing Columns for Faster Joins
Optimizing Hive Joins
Windowing Functions
Description
Course info
Rating
(45)
Level
Intermediate
Updated
Apr 25, 2017
Duration
3h 3m
Description

The Hive data warehouse supports analytical processing, it generally processes long-running jobs which crunch a huge amount of data. By understanding what goes on behind the scenes in Hive, you can structure your Hive queries to be optimal and performant, thus making your data analysis very efficient. In this course, Writing Complex Analytical Queries with Hive, you'll discover how to make design decisions and how to lay out data in your Hive tables. First, you'll dive into partitioning and bucketing, which are ways to reduce the data a query has to process. You'll cover how and when you use partitioning, bucketing, or both when you set up your tables. Next, you'll be introduced to the joins operation, along with covering how to deal with large tables, and run and optimize map-only joins. Lastly, you'll learn windowing functions, which allow you to write complex queries simply and easily with no intermediate tables. An important optimization with large datasets. By the end of this course, you'll develop an understanding for the little details that makes writing complex queries easier and faster.

About the author
About the author

A problem solver at heart, Janani has a Masters degree from Stanford and worked for 7+ years at Google. She was one of the original engineers on Google Docs and holds 4 patents for its real-time collaborative editing framework.

More from the author
Building Features from Image Data
Advanced
2h 10m
Aug 13, 2019
Designing a Machine Learning Model
Intermediate
3h 25m
Aug 13, 2019
More courses by Janani Ravi
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi. My name is Janani Ravi, and welcome to this course on Writing Complex Analytical Queries in Hive. I'll introduce myself first. I have a master's degree in Electrical Engineering from Stanford, and I have worked with companies such as Microsoft, Google, and Flipkart. At Google I was one of the first engineers working on real time collaborative editing in Google Docs, and I hold four patents for its underlying technologies. I currently work on my own startup, Loony Corn, a studio for high quality video content. Hive is a data warehouse that supports analytical processing. Analytical processing involves huge datasets summarizing and extracting insights from this dataset, and calculating trends. This basically means that Hive scripts tend to be very long running jobs, which require a lot of resources, but there is a lot you can do to make your queries run faster on Hive, and that's where this course comes in. This course helps you make design decisions on how to layout data in your Hive tables, partitioning and bucketing are ways to reduce the data your query has to process, understand how and when you would use partitioning, bucketing or both. Joining information from two or more tables is a very common operation, but it's often slow and inefficient in Hive. Learn how Hive deals with joins under the hood and how you can tweak your queries to have joins run faster. Lastly, we cover windowing functions. They allow you to write complex queries simply and easily with no intermediate tables. This course helps you understand the little details of Hive that makes writing complex queries easier and faster.