Section 1 : Introduction (Theory)

Lecture 1 Introduction to Hive 3:45
Lecture 2 About Proctor Testing Pdf
Lecture 3 Motivation of Hive 1:21
Lecture 4 Sql vs Hive 1:32
Lecture 5 Trailer- Working of Hive 2:8
Lecture 6 Architecture of Hive 4:58

Section 2 : Hive Basic Commands

Lecture 7 HADOOP AND HIVE INSTALLATION 8:18
Lecture 8 Create databases 7:15
Lecture 9 Table creation and loading data into it Part 1 8:16
Lecture 10 Table creation and loading data into it Part 2 3:33
Lecture 11 Internal vs External table- Explained 10:28
Lecture 12 Insert statement 6:30
Lecture 13 Multi insert statement (Advance) 2:44
Lecture 14 INTRODUCTION TO BRAINMEASURES PROCTOR SYSTEM Pdf
Lecture 15 Sorting -- sort by, order by, distribute by, cluster by 7:24

Section 3 : Functions in Hive

Lecture 16 Date and Mathematical functions 6:8
Lecture 17 String functions 5:39
Lecture 18 Split(), Substr(), instr() functions 3:6
Lecture 19 Conditional statements 4:57
Lecture 20 Explode and Lateral view ( Advance functions) 7:21
Lecture 21 Rlike function (Advance) 3:4
Lecture 22 About Certification Pdf

Section 4 : Partitioning in Hive

Lecture 23 What is Partitioning 1:42
Lecture 24 Static partitioning 7:2
Lecture 25 Dynamic partitioning 4:38
Lecture 26 Alter Partitioned Table and MSCK Repair command (Advance) 6:26

Section 5 : Bucketing in Hive

Lecture 27 What is Bucketing 2:27
Lecture 28 Create Bucketed Table 8:11
Lecture 29 Tablesampling (Advance) 5:9
Lecture 30 No_drop, Offline command (Advance) 5:4

Section 6 : Joins in Hive

Lecture 31 Inner Joins on 2 Tables
Lecture 32 Outer Joins on 2 Tables 4:35
Lecture 33 Join 3 Tables in Hive 4:32
Lecture 34 Memory Management & Optimization of Joins 2:23
Lecture 35 Map Joins (Advance) 5:47

Section 7 : Views in Hive

Lecture 36 What are views 2:7
Lecture 37 Creating Views in different ways 7:22
Lecture 38 Advantages of Views 2:40

Section 8 : Indexing (Advance)

Lecture 39 Creation of Indexes (Compact and Bitmap) 9:52
Lecture 40 Multiple Indexes on same table 8:16
Lecture 41 When and When not to use Indexing 1:33

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

Lecture 42 What is UDF 1:47
Lecture 43 UDF Implementation - Practical 7:41

Section 10 : Table Properties (Advance)

Lecture 44 Skipping Header and Footer records while loading in table 8:3
Lecture 45 INTRODUCTION TO BRAINMEASURES PROCTOR SYSTEM Pdf
Lecture 46 Immutable Table property 10:29
Lecture 47 Purge property + Difference between Drop and Truncate
Lecture 48 Null Format property 7:26
Lecture 49 ACIDTransactional features of Hive ( Advance) 10:12
Lecture 50 ORC Table properties 4:1

Section 11 : Configurations & Settings in Hive (Advance)

Lecture 51 Part 1 10:18
Lecture 52 Part 2 3:33
Lecture 53 Merge files in Hive 2:55
Lecture 54 Parallelism Property 6:38

Section 12 : Variables in Hive (Advance)

Lecture 55 Executing Hive queries from Bash shell 4:51
Lecture 56 Run Unix & Hadoop commands from Hive Shell 3:47
Lecture 57 Variables in Hive (hiveconf & hivevar) 6:47
Lecture 58 Difference between hiveconf & hivevar 2:30
Lecture 59 Using variables in bash shell 4:47
Lecture 60 Substituting value of a Variable 2:23

Section 13 : Different Types of Files in Hadoop

Lecture 61 Text, Sequence, Avro Files 5:35
Lecture 62 RC, ORC, Parquet Files 2:30
Lecture 63 Performance Test results of Various Files 2:39
Lecture 64 Which File Format to choose

Section 14 : Custom Input Fomatter (Advance)

Lecture 65 Using Custom Input Format in Hive 8:36

Section 15 : Miscellaneous (Advance)

Lecture 66 Modes of Hive 4:9
Lecture 67 Compression techniques in Hive 6:15
Lecture 68 Hiverc file (Creation and Uses) 9:27
Lecture 69 Archiving files in Hive 2:55

Section 16 : TEZ engine in Hive

Lecture 70 What is Tez engine and its comparison with MR

Section 17 : Load XML data in Hive

Lecture 71 How to Load XML data in Hive tables-- Part1 5:16
Lecture 72 How to Load XML data in Hive tables-- Part2 11:40

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

Lecture 73 What is Slowly changing Dimension (SCD) 7:26
Lecture 74 Implement SCD 1 in Hive--part1 11:28
Lecture 75 Implement SCD 1 in Hive--part2

Section 19 : Use Cases asked in Interviews

Lecture 76 Word count in Hive 6:45
Lecture 77 Multiple Tables on a single file 8:3