Hive to ADVANCE Hive Real time usage Hadoop querying tool

In and Out of Apache Hive – From Basic Hive to Advance Hive (Real-Time concepts) + Use cases asked in Interviews
Hive to ADVANCE Hive Real time usage Hadoop querying tool
File Size :
2.18 GB
Total length :
6h 58m



J Garg


Last update




Hive to ADVANCE Hive Real time usage Hadoop querying tool

What you’ll learn

Learn Full In and out of Apache HIVE (From Basic to Advance level).
Strength of this course is ADVANCE HIVE which consists of those Hive areas that are actually used in Real-time projects.
Querying and managing large datasets that reside in distributed storage using Hive.
Learn Interviews asked Questions and Use cases.
Data-sets and Hive queries are available in resources tab.

Hive to ADVANCE Hive Real time usage Hadoop querying tool


Basic Knowledge of Hadoop file system (HDFS)
Basic Knowledge of SQL
Rest everything is covered in this course (Hive + Advance Hive)


Apache Hive is a data processing tool on Hadoop. It is a querying tool for HDFS and the syntax of it’s queries is almost similar to our old SQL. Hive is an open source-software that lets programmers analyze large data sets on Hadoop.Benefits of this course:”Basic Hive is not sufficient if you want to work on Real-time projects.”Make yourself prepared to work on Real time Big data and Hive projects by learning Advance Hive from this course. Enroll into this course and 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.In this course you will get to understand a step by step learning of very Basic Hive to Advance Hive (which is actually used in Real-time projects) like:Variables in Hive Table properties of HiveCustom Input FormatterMap and Bucketed JoinsAdvance functions in HiveCompression techniques in Hive Configuration settings of HiveWorking with Multiple tables in HiveLoading Unstructured data in HiveAnd many more……This course is a full package explaining even rarely used commands and concepts in Hive. After completing this course you won’t find any topic left in Hive. This course is made keeping in mind the Real Implementation of Hive in Live Projects.Apart from this I have included 1 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. Additionally ,You can download the Step Step Installation Guide (pdf) to Install Hadoop and Apache Hive


Section 1: Introduction (Theory)

Lecture 1 Introduction to Hive

Lecture 2 Announcement

Lecture 3 Motivation of Hive

Lecture 4 Sql vs Hive

Lecture 5 Trailer- Working of Hive

Lecture 6 Architecture of Hive

Section 2: Hive Basic Commands


Lecture 8 Create databases

Lecture 9 Table creation and loading data into it |Part 1

Lecture 10 Table creation and loading data into it |Part 2

Lecture 11 Internal vs External table- Explained

Lecture 12 Insert statement

Lecture 13 Multi insert statement (Advance)

Lecture 14 Alter Table Schema

Lecture 15 Sorting — sort by, order by, distribute by, cluster by

Section 3: Functions in Hive

Lecture 16 Date and Mathematical functions

Lecture 17 String functions

Lecture 18 Split(), Substr(), instr() functions

Lecture 19 Conditional statements

Lecture 20 Explode and Lateral view ( Advance functions)

Lecture 21 Rlike function (Advance)

Lecture 22 Rank(), Dense_rank(), Row_number() (Advance)

Section 4: Partitioning in Hive

Lecture 23 What is Partitioning?

Lecture 24 Static partitioning

Lecture 25 Dynamic partitioning

Lecture 26 Alter Partitioned Table and MSCK Repair command (Advance)

Section 5: Bucketing in Hive

Lecture 27 What is Bucketing?

Lecture 28 Create Bucketed Table

Lecture 29 Tablesampling (Advance)

Lecture 30 No_drop, Offline command (Advance)

Section 6: Joins in Hive

Lecture 31 Inner Joins on 2 Tables

Lecture 32 Outer Joins on 2 Tables

Lecture 33 Join 3 Tables in Hive

Lecture 34 Memory Management & Optimization of Joins

Lecture 35 Map Joins (Advance)

Section 7: Views in Hive

Lecture 36 What are views?

Lecture 37 Creating Views in different ways

Lecture 38 Advantages of Views

Section 8: Indexing (Advance)

Lecture 39 Creation of Indexes (Compact and Bitmap)

Lecture 40 Multiple Indexes on same table

Lecture 41 When and When not to use Indexing

Section 9: UDF’s (User defined functions) Advance

Lecture 42 What is UDF

Lecture 43 UDF Implementation – Practical

Section 10: Table Properties (Advance)

Lecture 44 Skipping Header and Footer records while loading in table

Lecture 45 Immutable Table property

Lecture 46 Purge property + Difference between Drop and Truncate

Lecture 47 Null Format property

Lecture 48 ACID/Transactional features of Hive ( Advance)

Lecture 49 ORC Table properties

Section 11: Configurations & Settings in Hive (Advance)

Lecture 50 Part 1

Lecture 51 Part 2

Lecture 52 Merge files in Hive

Lecture 53 Parallelism Property

Section 12: Variables in Hive (Advance)

Lecture 54 Executing Hive queries from Bash shell

Lecture 55 Run Unix & Hadoop commands from Hive Shell

Lecture 56 Variables in Hive (hiveconf & hivevar)

Lecture 57 Difference between hiveconf & hivevar

Lecture 58 Using variables in bash shell

Lecture 59 Substituting value of a Variable

Section 13: Different Types of Files in Hadoop

Lecture 60 Text, Sequence, Avro Files

Lecture 61 RC, ORC, Parquet Files

Lecture 62 Performance Test results of Various Files

Lecture 63 Which File Format to choose

Section 14: Custom Input Fomatter (Advance)

Lecture 64 Using Custom Input Format in Hive

Section 15: Miscellaneous (Advance)

Lecture 65 Modes of Hive

Lecture 66 Compression techniques in Hive

Lecture 67 Hiverc file (Creation and Uses)

Lecture 68 Archiving files in Hive

Section 16: TEZ engine in Hive

Lecture 69 What is Tez engine and its comparison with MR

Section 17: Load XML data in Hive

Lecture 70 How to Load XML data in Hive tables– Part1

Lecture 71 How to Load XML data in Hive tables– Part2

Section 18: Implementing SCD’s in Hive (Advance)

Lecture 72 What is Slowly changing Dimension (SCD)

Lecture 73 Implement SCD 1 in Hive–part1

Lecture 74 Implement SCD 1 in Hive–part2

Section 19: Use Cases asked in Interviews

Lecture 75 Word count in Hive

Lecture 76 Multiple Tables on a single file

Student who wants to learn Basic Hive + ADVANCE HIVE (Real Project Oriented).,Software Engineers who want to learn What and How Hive queries are used in Real time projects.,Techies who wants to get knowledge of Real-time Hive Use cases asked in Interviews.

Course Information:

Udemy | English | 6h 58m | 2.18 GB
Created by: J Garg

You Can See More Courses in the IT & Software >> Greetings from

New Courses

Scroll to Top