#### 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