Advanced Analytical Queries in Hive

Advanced Queries : Partitioning, Bucketing, UDFs, Windowing, Join Optimization

What's Inside

Course Description

Prerequisites: Hive requires knowledge of SQL. This course covers advanced features of Hive that are not present in SQL

Taught by a 4 person team including 2 Stanford-educated, ex-Googlers and 2 ex-Flipkart Lead Analysts. This team has decades of practical experience in working with large-scale data.

This course is an advanced guide to using Hive for writing complex, performant analytical queries.

Hive helps you leverage the power of Distributed computing and Hadoop for Analytical processing. It's interface is like an old friend : the very SQL like HiveQL. This course will help you take advantage of Hive features that help you tune performance and do complex transformations.

Practical: Everything is taught using real-life examples, working queries and code .

What's Covered:

Analytical Processing: Subqueries, Table Generating Functions, Explode, Lateral View, Windowing and more

Tuning Hive for better functionality: Partitioning, Bucketing, Join Optimizations, Map Side Joins, Implementation of MapReduce for Select, Group by and Join

Talk to us!

  • Mail us about anything - anything! - and we will always reply :-)


What are the requirements?

  • Hive requires knowledge of SQL.

What am I going to get from this course?

  • Write complex analytical queries on data in Hive and uncover insights
  • Leverage ideas of partitioning, bucketing to optimize queries in Hive
  • Understand what goes on under the hood of Hive with HDFS and MapReduce

What is the target audience?

  • Yep! Analysts who want to write complex analytical queries on large scale data
  • Yep! Engineers who want to know more about managing Hive as their data warehousing solution

Course Curriculum

Get started now!



Certificate Available
355+ Students
49 Lectures
7+ Hours of Video
Lifetime Access
24/7 Support
Instructor Rating
Loonycorn

Loonycorn is comprised of a couple of individuals —Janani Ravi and Vitthal Srinivasan—who have honed their tech expertises at Google and Stanford. The team believes it has distilled the instruction of complicated tech concepts into funny, practical, engaging courses, and is excited to be sharing its content with eager students.

Popular Bundles