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.
"Apache Hive is an open source data processing tool on Hadoop that enables programmers to analyze large datasets stored in HDFS by using SQLlike 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 ofBasic + 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 BucketedJoins
Advance functions in Hive
ACID features of Hive
User defined functions (UDFs) in Hive
Compression techniques in Hive
Configuration settings ofHive
Working with Multiple tables in Hive
Loading Unstructured data in Hive
and many more...
Thiscourse is a complete packageexplaining even rarely used commands and conceptsin 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 haveexplainedthe frequentlyasked Use cases with their proper practical working in Hive.
