Learning Apache Hadoop EcoSystem- Hive

Learn Apache Hive and Start working with SQL queries which is on Data which is in Hadoop
4.3 (408 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.
12,868 students enrolled
Instructed by Balaji M Development / Databases
Free
Start Learning Now
  • Lectures 29
  • Length 4.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 9/2014 English

Course Description

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.

What are the requirements?

  • 64 Bit OS to download VM and work along with videos.

What am I going to get from this course?

  • Install and Work on Hive
  • Troubleshoot Hive Issues
  • Partition and bucket data

What is the target audience?

  • Any one with Basic understanding of Hadoop and basics of SQL

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: What? Why ? How Hive Works
04:07

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 Hive is Not
03:16
Hadoop Recap
02:25
Hive Architecture
05:29
Different Modes of Hive
05:44
Hive Server 2 Concepts and Recap of Section 1
04:07
Concepts - Quiz
6 questions
Section 2: Installation , Configuration and Demo on Hive
CDH, CM and VM
05:57
How to Download VM and Hive Demo
19:52
Hive Shell Commands
10:57
Different Configuration Properties in Hive
09:43
Beeswax
13:11
Install and Configure MySQL Database
14:37
Install Hive Server 2
13:05
Hive Quiz -2
5 questions
Section 3: Working on Hive
Databases in Hive
07:48
Datatypes in HIve
03:36
Schema on Read and Schema on Write
03:56
Download Datasets
05:56
Internal Tables
15:13
External Tables
11:51
Partition 1A
14:14
Partition 1B
11:23
Bucketing 1A
14:32
Bucketing 1B
07:22
Quiz on Tables
5 questions
Section 4: Hive Implementations in Real Time Projects
Hive In Real Time Projects
15:41
Auditing in Hive
11:01
Troubleshooting Infra issues in Hive
11:13
Troubleshooting User issues in Hive
05:58
Quiz on Troubleshooting
2 questions
Section 5: Thank you and Project as Exercise
Thank you
02:44
Project
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Balaji M, 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.

Ready to start learning?
Start Learning Now