Wishlisted Wishlist

Please confirm that you want to add Learning Apache Hadoop EcoSystem- Hive to your Wishlist.

Add to Wishlist

Learning Apache Hadoop EcoSystem- Hive

Learn Apache Hive and Start working with SQL queries which is on Data which is in Hadoop
4.2 (544 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
15,201 students enrolled
Created by Balaji M
Last updated 11/2015
  • 4.5 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

This tutorial starts with understanding need for hive Architecture and different configuration parameters in Hive. During this course you will learn different aspects of Hive and how it fits as datawarehousing patform on Hadoop. Please subscribe to my Youtube Channel "Hadooparch" for more details.

This Course covers Hive, the SQL of Hadoop.(HQL) We will learn why and How Hive is installed and configured on Hadoop. We will cover the components and architecture of Hive to see how it stores data in table like structures over HDFS data. Understabd architecture, installation and configuration of Hive. We will install and configure Hive server2 and replace postgresql database with mysql. we will also learn how to install mysql and configure it as Hive Metastore

This Course is full of Hive demonstrations. We'll cover how to create Databases, understand data types, create external, internal, and partitioned hive tables, bucketing load data from the local filesystem as well as the distributed filesystem (HDFS), setup dynamic partitioning, create views, and manage indexes and how different layers work together on Hive.

We will go through different roles in implementing in Real time projects, how projects are set up and permissions, Auditing, Troubleshooting.

Finally I will give sample data and queries to work and replicate what has been taught in Videos.

This Course has multiple questions to test your understanding. Kindly attempt all of them.

Who is the target audience?
  • Any one with Basic understanding of Hadoop and basics of SQL
Students Who Viewed This Course Also Viewed
What Will I Learn?
Install and Work on Hive
Troubleshoot Hive Issues
Partition and bucket data
View Curriculum
  • 64 Bit OS to download VM and work along with videos.
Curriculum For This Course
Expand All 29 Lectures Collapse All 29 Lectures 04:17:04
What? Why ? How Hive Works
6 Lectures 25:08

What is Hive ?

Apache Hive is a popular SQL interface for batch processing on Hadoop. Hadoop was built to organize and store massive amounts of data Hive gives another way to access Data inside the cluster in easy, quick way.

What is Hive , What was the Motivation and Used Cases

What Hive is Not

Hadoop Recap

Hive Architecture

Different Modes of Hive

Hive Server 2 Concepts and Recap of Section 1

Concepts - Quiz
6 questions
Installation , Configuration and Demo on Hive
7 Lectures 01:27:22
CDH, CM and VM

How to Download VM and Hive Demo

Hive Shell Commands

Different Configuration Properties in Hive


Install and Configure MySQL Database

Install Hive Server 2

Hive Quiz -2
5 questions
Working on Hive
10 Lectures 01:35:51
Databases in Hive

Datatypes in HIve

Schema on Read and Schema on Write

Download Datasets

Internal Tables

External Tables

Partition 1A

Partition 1B

Bucketing 1A

Bucketing 1B

Quiz on Tables
5 questions
Hive Implementations in Real Time Projects
4 Lectures 43:53
Hive In Real Time Projects

Auditing in Hive

Troubleshooting Infra issues in Hive

Troubleshooting User issues in Hive

Quiz on Troubleshooting
2 questions
Thank you and Project as Exercise
2 Lectures 04:36
Thank you

About the Instructor
4.2 Average rating
540 Reviews
15,201 Students
1 Course
Hadoop Trainer and Enthusiast

I have experience of over 8 years. My Experience varies from working in an IT company to Starting up a design factory. I have worked with CMMi level 5 companies and provided services to clients in various areas including BIG DATA implementations.

My Passion is/was always explain concepts as simple as possible. I love Learning new technologies and Integration of technologies is my Passion. As Internet is full of all possible courses on Hadoop, I want to add courses on hadoop ecosystem products which made Hadoop popular.

Report Abuse