Library

Course: Advance Hive: Zero to Expert in Big Data Analytics

Advance Hive: Zero to Expert in Big Data Analytics

  • Life Time Access
  • Certificate on Completion
  • Access on Android and iOS App
  • Self-Paced
About this Course

You will start by learning what is Hadoop & Hadoop distributed file system.

This course will teach you Apache Hive [Advance]

  • Hive Intro
  • External & Managed Tables
  • Insert & Multi Insert
  • Data Types & Complex Data Types
  • Collection Function
  • Conditional Function
  • Hive String Functions
  • Hive Date Functions
  • Mathematical Function
  • Hive Analysis
  • Alter Command
  • Joins, Multi Joins & Map Joins
  • Working with Different Files - Parquet,Avro
  • Compressions
  • Partitioning
  • Bucketing
  • Views
  • Lateral Views/Explode
  • Windowing Functions - Rank/Dense Rank/lead/lag/min/max
  • Window Specification
Basic knowledge
  • Hive is Big Data Analytics tool that is built on top of Hadoop Distributed File system and can do various kind of analytics on top of data distributed over multiple machines
What you will learn
  • Advance Hive & Big Data Analytics
Curriculum
Number of Lectures: 32
Total Duration: 02:32:06
Hadoop Introduction
  • Hadoop Distributed File System  
Apache Hive
  • Hive Introduction  
  • Hive Database  
  • Managed Table  
  • External Table  
  • Hive Inserts  
  • Hive Multi Inserts  
  • Data Types Introduction  
  • Array DataType  
  • Map DataType  
  • Struct DataType  
  • Alter Command  
Hive Functions
  • Collection Functions  
  • Conditional Functions  
  • String Functions  
  • Date Functions  
  • Mathematical Functions  
  • Hive Analytics  
Hive Joins
  • Joins  
  • Multi Joins  
  • Map Joins  
File Formats
  • Working With Parquet  
  • Working with Parquet Compression  
  • Working with Fixed File Formats  
Advance Hive
  • Dyanmic Partitioning  
  • Bucketing  
  • Views  
  • Lateral View/Explode  
Hive Windows Functions
  • Rank/ Dense Rank/Row Number  
  • Lead/Lag  
  • Min/Max  
  • Window Specifications  
Reviews (0)