Introduction to Apache Hive

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!

4.5
average rating

Ratings

Beginner

Level

6.0 Hrs

Learning hours

10.8K+
local_fire_department

Learners

Skills you’ll Learn

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.

Why upskill with us?

check circle outline
700+ free courses
In-demand skills & tools
access time
Free life time Access

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

Trusted by 10 Million+ Learners globally

What our learners say about the course

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

4.5
Course Rating
70%
21%
6%
0%
3%

What our learners enjoyed the most

Introduction to Apache Hive

6.0 Learning Hours . Beginner

Why upskill with us?

check circle outline
700+ free courses
In-demand skills & tools
access time
Free life time Access