Hive to ADVANCE Hive (Real time usage) :Hadoop querying tool

In and Out of Apache Hive - From Basic to Advance Hive (Real-world concepts) + Use cases asked in Hive interviews

Created by: J Garg
Senior Big data Consultant in a prestigious MNC

What Will I 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)

Target audience

• 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.