Hive to ADVANCE Hive (Real time usage) :Hadoop querying tool (Udemy.com)
In and Out of Apache Hive - From Basic to Advance Hive (Real-world concepts) + Use cases asked in Hive interviews
Created by: J Garg
Last updated May 2025
What you will learn
- Learn the complete in-and-out details of Apache Hive from Basic to Advance level.
- Start by exploring the fundamentals of Hive including Hive's Introduction, Architecture, Installation, SQL vs Hive etc.
- Learn Basic Hive concepts to Create Databases & Tables, Insert data, Joins, Views, Mathematical functions, String functions, Conditional statements etc.
- Strength of this course is ADVANCE HIVE, covering those Hive features that are actively used in Real-time projects.
- Partitioning, Bucketing, Explode & Lateral views, Tablesampling, Variables, Optimized Map Joins, User defined functions (UDFs)
- ACID features of Hive, Different types of files in Hive, Custom input formatter, Archiving and Compression techniques etc.
- Learn about various Hive Tableproperties - Skip header & footer, Immutable table, Purge, Null format, Parallelism and ORC table properties.
How it compares
Against the other 150 rated Udemy courses in Hadoop on CourseDuck:
- Rating4.5 out of 5higher than 68% of them
- Reviews6,431#10 of 151 by number of reviews
- Length7 hourslonger than 57% of them
- Last updatedMay 2025more recently than 70% of them
Course Description
"Apache Hive is an open source data processing tool on Hadoop that enables programmers to analyze large datasets stored in HDFS by using SQL like queries."
"Basic Hive is not sufficient if you want to work on Real-world projects.”
Make yourself prepared to work on Real time Big data and Hive projects by learning Advance Hive from this course. In this course you will get end-to-end knowledge of Basic + ADVANCE Hive + Interview asked Use cases. This course is very rare of its kind and includes even very thin details of Hive which are not available anywhere online.
What in nutshell is included in the course ?
Learn the Basic Hive concepts to kickstart your learning including :
Introduction to Hive tool, Architecture, Installation, SQL vs Hive.
Create Databases & Tables and insert data into them.
Internal vs External tables concept in Hive
Joins, Views, Mathematical functions, Date functions, String functions, Conditional statements etc.
Learn the ADVANCE Hive concepts that are actively used in Real-world projects like:
Variables in Hive
Partitioning and Bucketing in Hive
Explode & Lateral view in Hive
Table properties of Hive
Custom Input Formatter
Map and Bucketed Joins
Advance functions in Hive
ACID features of Hive
User defined functions (UDFs) in Hive
Compression techniques in Hive
Configuration settings of Hive
Working with Multiple tables in Hive
Loading Unstructured data in Hive
and many more...
This course is a complete package explaining even rarely used commands and concepts in Hive. After completing this course you won't find any topic left.
Apart from this I have included one more section which is Use cases asked in Interviews. Usually students can answer the direct questions asked by Interviewers but got stuck on Use cases . For that I have explained the frequently asked Use cases with their proper practical working in Hive.
Instructor Details
- 4.5 Rating
6,431 Reviews
J Garg
Working as a Senior Big data Consultant in a well known MNC. Have 11 years of experience in Hadoop Technologies and Data analysis. I have implemented many end to end customer projects while serving the role of Technical Lead. I am also engaged in Classroom training and training freshers in my Company.
More courses by J Garg
MLOps Fundamentals - Learn MLOps Concepts with Azure demo (2025)
4.4 (10,408 Reviews)
Provider: Udemy
Time: 2.9h
$10.99
BigQuery for Big data engineers - Master Big Query Internals (2025)
4.4 (4,390 Reviews)
Provider: Udemy
Time: 8.8h
$10.99
Apache Flink | A Real Time & Hands-On course on Flink (2025)
4.4 (2,897 Reviews)
Provider: Udemy
Time: 5.8h
$10.99
Apache Beam | A Hands-On course to build Big data Pipelines (2025)
4.4 (2,116 Reviews)
Provider: Udemy
Time: 5.4h
$10.99
Hadoop MAPREDUCE in Depth | A Real-Time course on Mapreduce (2025)
4.4 (512 Reviews)
Provider: Udemy
Time: 5.9h
$64.99
BigQuery ML - Machine Learning in Google BigQuery using SQL (2025)
4.4 (502 Reviews)
Provider: Udemy
Time: 11.1h
$84.99
More Hadoop courses
Spark Streaming - Stream Processing in Lakehouse - PySpark (2024)
4.9 (2,251 Reviews)
Provider: Udemy
Time: 22.4h
$11.99
Apache Kafka Series - KSQL on ksqlDB for Stream Processing ! (2026)
4.9 (2,161 Reviews)
Provider: Udemy
Time: 4h
$12.99
Apache Kafka Series - Kafka Streams for Data Processing (2026)
4.8 (6,826 Reviews)
Provider: Udemy
Time: 4.8h
$14.99
Apache Kafka Series - Confluent Schema Registry & REST Proxy (2026)
4.8 (3,794 Reviews)
Provider: Udemy
Time: 4.5h
$94.99
Apache Kafka - Real-time Stream Processing (Master Class) (2023)
4.8 (2,925 Reviews)
Provider: Udemy
Time: 11h
$10.99
Apache Spark 3 & Big Data Essentials in Scala (2024)
4.8 (2,302 Reviews)
Provider: Udemy
Time: 7.3h
$39.99
Reviews
By Amit Priyadarshi on 4/26/2020
Excellent and very detailed course on Hive. Covering a lot of scenarios which are used in actual production env. Only feedback I have is that there are just so many of random data and random tables like table1, table 16 is used which could have converted into one or two proper dataset and create proper table names like employee, orders products etc. Nevertheless the course is still awesome and trainer talks straight to the point without wasting time and topics are of real production use.
By Chhavi on 4/25/2020
The course curriculum is very apt, wide, and to the point. - 5 stars for that The instructor has tried to cover as many topics as he could - 5 stars to that The recording is quite unstable in a few lectures - 4 stars Few things are supposedly technical jargon - so it is not for all levels until explained - 3.5 stars Steps for the setup for self-practice - 3 stars
By Rohan chaturvedi on 4/10/2020
I felt like some portion about 10% (which is not less) is taken for granted by the teacher that a learner must know but i, like many others, was new to hadoop and hive and didn't have any prior knowledge. My suggestion is to increase the length of the videos but explain everything that is being spoken in the video. This would be beneficial for both the course ratings and learners.Thanks.
By Oscar García Ramírez on 1/2/2020
In general, it was what I expected. Very good course although improvable in some things. There are quite well explained sections, showing in detail each step with presentations and practices. However, there are a few very improvable sections, in which I have had to look for information outside the course in order to understand them correctly. I rate it with a 4/5 for those ups and downs at the level of the explanations of the sections.
By William Schmidt on 9/25/2019
This was an excellent course; concise, detailed, great explanation of concepts, and very complete. The instructor gives a complete and through grounding in all the basics. If you pay attention, you will learn everything needed to contribute to a big data team and become an expert Hive developer after practicing and honing the skills imparted in this course.
By Henil Shelat on 3/6/2019
I had clearly no experience in Hive when I took this course. But now I have gotten a good hands-on experience from the course and also the course seems to be very good when it comes it including the complete or all round details for Hive and Hadoop instead of just showing the basic commands which you will get in every documentation or tutorials. So I would suggest this course to everyone or anyone who wants to have a good all-round experience in Hive and Hadoop.
By Anonymized User on 9/14/2018
Course is very good. It covers all the topics with examples. No doubt this course is really very good but still I would like to make 2 suggestions to trainer: 1. Merge all the resources to a single zip and add all topics and files to it what is covered in sections. 2. Please don't indirectly force someone to buy your other MapRed course. It's completely ok to suggest other course but its better to add examples (like in UDX you tried to hide it). Maybe explanation is beyond scope but atleast you could have added that working example.
By Varun Attri on 7/18/2018
Looking for a hive course for a long time then found this one. Content is good and this course has cleared many concepts. Instructor's teaching style is very good and he has decent knowledge of the topic. In case of any query the instructor responds very quickly and always give satisfying answer. Good course by J Garg. Thanks for the course.
By Smith on 6/27/2018
Very much Informative.I really feel myself confident on hive now.I am impressed by the course's inclusions. The course provides a boilerplate of hive queries that is used in Realtime projects. One can use this boilerplate and tweak the queries according to the needs. The way of teaching and accent is also very simple. Would love to take his other courses also in future.
By Prateek on 6/3/2018
This is more than a 5 star course. The way this course is structured, one will never find himself lost in the topics. Garg is an instructor with the real-world experience. He is concise and always to the point. If you got any doubts (which has very little probability), then you can easily reach him in Q&A and can get your doubts clear. You will never feel it like a computer-based training rather you will feel it like a 'live class'. Thumbs Up!
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 90 / 100












