Section 1 : Introduction (Theory)

Lecture 1 Introduction to Hive 00:03:45 Duration
Lecture 2 About Proctor Testing
Lecture 3 Motivation of Hive 00:01:21 Duration
Lecture 4 Sql vs Hive 00:01:32 Duration
Lecture 5 Trailer- Working of Hive 00:02:08 Duration
Lecture 6 Architecture of Hive 00:04:58 Duration

Section 2 : Hive Basic Commands

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

Section 3 : Functions in Hive

Lecture 1 Date and Mathematical functions 00:06:08 Duration
Lecture 2 String functions 00:05:39 Duration
Lecture 3 Split(), Substr(), instr() functions 00:03:06 Duration
Lecture 4 Conditional statements 00:04:57 Duration
Lecture 5 Explode and Lateral view ( Advance functions) 00:07:21 Duration
Lecture 6 Rlike function (Advance) 00:03:04 Duration
Lecture 7 About Certification

Section 4 : Partitioning in Hive

Lecture 1 What is Partitioning 00:01:42 Duration
Lecture 2 Static partitioning 00:07:02 Duration
Lecture 3 Dynamic partitioning 00:04:38 Duration
Lecture 4 Alter Partitioned Table and MSCK Repair command (Advance) 00:06:26 Duration

Section 5 : Bucketing in Hive

Lecture 1 What is Bucketing 00:02:27 Duration
Lecture 2 Create Bucketed Table 00:08:11 Duration
Lecture 3 Tablesampling (Advance) 00:05:09 Duration
Lecture 4 No_drop, Offline command (Advance) 00:05:04 Duration

Section 6 : Joins in Hive

Lecture 1 Inner Joins on 2 Tables
Lecture 2 Outer Joins on 2 Tables 00:04:35 Duration
Lecture 3 Join 3 Tables in Hive 00:04:32 Duration
Lecture 4 Memory Management & Optimization of Joins 00:02:23 Duration
Lecture 5 Map Joins (Advance) 00:05:47 Duration

Section 7 : Views in Hive

Lecture 1 What are views 00:02:07 Duration
Lecture 2 Creating Views in different ways 00:07:22 Duration
Lecture 3 Advantages of Views 00:02:40 Duration

Section 8 : Indexing (Advance)

Lecture 1 Creation of Indexes (Compact and Bitmap) 00:09:52 Duration
Lecture 2 Multiple Indexes on same table 00:08:16 Duration
Lecture 3 When and When not to use Indexing 00:01:33 Duration

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

Lecture 1 What is UDF 00:01:47 Duration
Lecture 2 UDF Implementation - Practical 00:07:41 Duration

Section 10 : Table Properties (Advance)

Lecture 1 Skipping Header and Footer records while loading in table 00:08:03 Duration
Lecture 2 INTRODUCTION TO BRAINMEASURES PROCTOR SYSTEM
Lecture 3 Immutable Table property 00:10:29 Duration
Lecture 4 Purge property + Difference between Drop and Truncate
Lecture 5 Null Format property 00:07:26 Duration
Lecture 6 ACIDTransactional features of Hive ( Advance) 00:10:12 Duration
Lecture 7 ORC Table properties 00:04:01 Duration

Section 11 : Configurations & Settings in Hive (Advance)

Lecture 1 Part 1 00:10:18 Duration
Lecture 2 Part 2 00:03:33 Duration
Lecture 3 Merge files in Hive 00:02:55 Duration
Lecture 4 Parallelism Property 00:06:38 Duration

Section 12 : Variables in Hive (Advance)

Lecture 1 Executing Hive queries from Bash shell 00:04:51 Duration
Lecture 2 Run Unix & Hadoop commands from Hive Shell 00:03:47 Duration
Lecture 3 Variables in Hive (hiveconf & hivevar) 00:06:47 Duration
Lecture 4 Difference between hiveconf & hivevar 00:02:30 Duration
Lecture 5 Using variables in bash shell 00:04:47 Duration
Lecture 6 Substituting value of a Variable 00:02:23 Duration

Section 13 : Different Types of Files in Hadoop

Lecture 1 Text, Sequence, Avro Files 00:05:35 Duration
Lecture 2 RC, ORC, Parquet Files 00:02:30 Duration
Lecture 3 Performance Test results of Various Files 00:02:39 Duration
Lecture 4 Which File Format to choose

Section 14 : Custom Input Fomatter (Advance)

Lecture 1 Using Custom Input Format in Hive 00:08:36 Duration

Section 15 : Miscellaneous (Advance)

Lecture 1 Modes of Hive 00:04:09 Duration
Lecture 2 Compression techniques in Hive 00:06:15 Duration
Lecture 3 Hiverc file (Creation and Uses) 00:09:27 Duration
Lecture 4 Archiving files in Hive 00:02:55 Duration

Section 16 : TEZ engine in Hive

Lecture 1 What is Tez engine and its comparison with MR

Section 17 : Load XML data in Hive

Lecture 1 How to Load XML data in Hive tables-- Part1 00:05:16 Duration
Lecture 2 How to Load XML data in Hive tables-- Part2 00:11:40 Duration

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

Lecture 1 What is Slowly changing Dimension (SCD) 00:07:26 Duration
Lecture 2 Implement SCD 1 in Hive--part1 00:11:28 Duration
Lecture 3 Implement SCD 1 in Hive--part2

Section 19 : Use Cases asked in Interviews

Lecture 1 Word count in Hive 00:06:45 Duration
Lecture 2 Multiple Tables on a single file 00:08:03 Duration