When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.

Udemy logo

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

     
  • 4
  •  |
  • Reviews ( 6.2K )
₹549

This Course Includes

  • iconudemy
  • icon4 (6.2K reviews )
  • icon6h 58m
  • iconenglish
  • iconOnline - Self Paced
  • iconprofessional certificate
  • iconUdemy

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

_"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.

What You Will 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. Show moreShow less.