Introduction to Apache Hive

4.55
learner icon
9.9K+ Learners
beginner
Beginner

Enroll In Online Apache Free Course & Get Free Certificate On Completion. Also Get Access To 1000+ Free Courses With Free Certificates Now. No Ads Or Payment. Just Sign Up For Free!

What you learn in Introduction to Apache Hive ?

tick
Hive basics
tick
Hive querying
tick
Hive data upload
tick
Hive simple operations

About this Course

This is an introductory course on one of the most used tools in big data - Apache Hive, an ETL(Extraction, Transformation, and Loading) tool, and data warehouse infrastructure software that can create interaction between users and Hadoop Distributed File System (HDFS). The course starts with the introduction to Hive before progressing to the following topics, which utilize a hands-on approach to explain. You will learn internal and external table structures, reading data from different formats into Hive structure. With the help of an easy and intuitive explanation, you will get a good grasp of how to load data into Hive, querying techniques, and generate views in Hive tables.

One of the best e-learning institutes in India, Great Lakes Executive Learning, offers you a world-class Post-Graduate Program in the Cloud Computing domain. Register yourself in India’s #1 ranked cloud computing course and, after completing the program, secure a Postgraduate Certificate in the Cloud Computing field from Great Lakes Executive Learning. Our faculty and mentors team comprises leading academicians in Cloud Computing and various experienced industry professionals from top-notch organizations.

Course Outline

Introduction to Hive
Hive Demo - Basics and Internal Table

The internal table gets created by default in a specific location in Apache Hive when the user does not specify it as external, with the path similar to /user/hive/warehouse directory of HDFS.

Hive Demo - External table
Hive Demo - Loading Different File Formats

Text files, SequenceFile, RCFile, Avro files. ORC files, Parquet, Custom INPUT FORMAT, and OUTPUT FORMAT are the different file formats supported by Apache Hive.

Hive Demo - Load Data Into Hive Table

Start Hadoop Daemon, launch hive terminal hive, write commands and insert query. You will then be able to load data into hive tables.  

Hive Demo - Query Operations on Hive Table

Hive queries are performed using SELECT statements. This section will demonstrate how to query on the Hive table. 

Hive Demo - Querying Complex Structures from a Table

SHOW SCHEMA, SHOW TABLES, and USE are the most commonly used queries/commands in Apache Hive. You will understand working with it better with examples in this section.

Views in Hive

What our learners say about the course

Find out how our platform helped our learners to upskill in their career.

4.55
Course Rating
72%
22%
3%
0%
3%

Introduction to Apache Hive

With this course, you get

clock icon

Multi device access

Learn anytime, anywhere

medal icon

Completion Certificate

Stand out to your professional network

medal icon

4.0 Hours

of self-paced video lectures

share icon

Share with friends