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 Hive
Custom Input Formatter
Map and Bucketed Joins
Advance functions in Hive
Compression techniques in Hive
Configuration settings of Hive
Working with Multiple tables in Hive
Loading Unstructured data in Hive
And 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
Who this course is for:
Student who wants to learn Basic Hive + ADVANCE HIVE (Real Project Oriented).
Software Engineers who wants to learn What and How Hive queries are used in Real time projects.
Techies who wants to get knowledge of Real-time Use cases asked in Interviews.
Rating: 4.5 out of 59 months ago
Thanks to the author for designing the course. It's a good course covered most of the stuff in the hive.
Little disappointment if the author needs to cover more on windowing function and more performance optimization techniques.
That's the only drawback apart,a very good course to gain a decent knowledge in the hive.
19 sections • 77 lectures • 7h 2m total length
Motivation of Hive
Sql vs Hive
Architecture of Hive
HADOOP AND HIVE INSTALLATION
Table creation and loading data into it |Part 2
Internal vs External table- Explained
Multi insert statement (Advance)
Alter Table Schema
Sorting -- sort by, order by, distribute by, cluster by
Date and Mathematical functions
Split(), Substr(), instr() functions
Explode and Lateral view ( Advance functions)
Rlike function (Advance)
Rank(), Dense_rank(), Row_number() (Advance)
Practice Mathematical Functions
What is Partitioning?
Alter Partitioned Table and MSCK Repair command (Advance)
Create Bucketed Table
No_drop, Offline command (Advance)
Inner Joins on 2 Tables
Outer Joins on 2 Tables
Join 3 Tables in Hive
Memory Management & Optimization of Joins
What are views?
Creating Views in different ways
Advantages of Views
Creation of Indexes (Compact and Bitmap)
Multiple Indexes on same table
When and When not to use Indexing
What is UDF
UDF Implementation - Practical
Skipping Header and Footer records while loading in table
Immutable Table property
Purge property + Difference between Drop and Truncate
Working as a Senior Big data Consultant in a well known MNC. Have 6.5 years of experience in Hadoop Technologies and Data analysis. I have implemented many end to end customer projects while serving the role of Technical Lead. I am also engaged in Classroom training and training freshers in my Company.