Hive to ADVANCE Hive (Real time usage) :Hadoop querying tool
What you'll learn
- Learn the complete in-and-out details of Apache Hive from Basic to Advance level.
- Start by exploring the fundamentals of Hive including Hive's Introduction, Architecture, Installation, SQL vs Hive etc.
- Learn Basic Hive concepts to Create Databases & Tables, Insert data, Joins, Views, Mathematical functions, String functions, Conditional statements etc.
- Strength of this course is ADVANCE HIVE, covering those Hive features that are actively used in Real-time projects.
- Partitioning, Bucketing, Explode & Lateral views, Tablesampling, Variables, Optimized Map Joins, User defined functions (UDFs)
- ACID features of Hive, Different types of files in Hive, Custom input formatter, Archiving and Compression techniques etc.
- Learn about various Hive Tableproperties - Skip header & footer, Immutable table, Purge, Null format, Parallelism and ORC table properties.
- Implement Slowly changing Dimensions (SCD 1) using Hive queries.
- How to create a Hive table for XML data and load data in it.
- Learn Interviews asked Hive Questions and Use cases.
Requirements
- Basic Knowledge of Hadoop file system (HDFS)
- Basic Knowledge of SQL
- Rest everything is covered in this course (Hive + Advance Hive)
Description
"Apache Hive is an open source data processing tool on Hadoop that enables programmers to analyze large datasets stored in HDFS by using SQL like queries."
"Basic Hive is not sufficient if you want to work on Real-world projects.”
Make yourself prepared to work on Real time Big data and Hive projects by learning Advance Hive from this course. In this course you will 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.
What in nutshell is included in the course ?
Learn the Basic Hive concepts to kickstart your learning including :
Introduction to Hive tool, Architecture, Installation, SQL vs Hive.
Create Databases & Tables and insert data into them.
Internal vs External tables concept in Hive
Joins, Views, Mathematical functions, Date functions, String functions, Conditional statements etc.
Learn the ADVANCE Hive concepts that are actively used in Real-world projects like:
Variables in Hive
Partitioning and Bucketing in Hive
Explode & Lateral view in Hive
Table properties of Hive
Custom Input Formatter
Map and Bucketed Joins
Advance functions in Hive
ACID features of Hive
User defined functions (UDFs) 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 complete package explaining even rarely used commands and concepts in Hive. After completing this course you won't find any topic left.
Apart from this I have included one 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.
Who this course is for:
- Data Engineers who wants to learn Basic Hive + ADVANCE HIVE (Real Project Oriented).
- Candidates who wants to gain knowledge of Real-world Hive Use cases asked in Interviews.
Featured review
Instructor
- 4.5 Instructor Rating
- 5,748 Reviews
- 27,983 Students
- 1 Course
Working as a Senior Big data Consultant in a well known MNC. Have 11 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.