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 |