Preview Apache Hive for Data Engineers (Hands On) with 2 Projects

Back

Introduction

Introduction to Course

Introduction to Apache Hive

Hive Architecture

How a Hive query flows through the system.

(Optional) Introduction to Big Data

(Optional) What is Hadoop

Hive Features

Hive Limitation

Installing Apache Hive on Ubuntu (Linux) Machine

Installation Steps of Hadoop

Installation Steps of Apache Hive

Hive Data Model

Hive Data Model Diagram

Tables

Partitions

Buckets or Clusters

Hive Data Types

Primitive Type

Complex Type

HIVE Data Definition Language.

Create Database

Drop Database

Alter Database

Use Database

Show Databases

Descbribe Databases

Create Table

Create Table (Hands On)

Create Table (Hands On) with all Primitive Datatype

Downloadable materials

Create Table (Hands On) with all Complex Datatype

Downloadable materials for Table

Managed and External Tables

Managed and External Tables (Hands On)

Storage Formats

Show Tables

Describe Tables

Drop Table

Alter Table

Truncate Table

HIVE Data Manipulation Language

LOAD

SELECT

INSERT

UPDATE

Downloadable materials for Update

DELETE

Hive View, Metastore, Partitions, and Bucketing

View

View (Hands On)

Metastore

Partitions

Partitions (Hands On)

Bucketing

Bucketing (Hands On)

Hive Interactive Shell Commands

Execute Hive Queries in “One Shot” Commands

Executing Hive Queries from Files

Hive Variable

Hive Built-In Functions

Date Functions

Mathematical Functions

String Functions

Built-in Operators

Relational Operators

Arithmatic Operators

Logical Operators

String Operators

Hive Join

Joins

Inner Join (Hands On)

Left Outer Join (Hands On)

Right Outer Join (Hands On)

Full Outer Join (Hands On)

Working with XML and JSON

Loading XML in Hive

Loading JSON in Hive

XML

JSON

Frequently Asked Interview Question and Answers

How to create HIVE Table with multi character delimiter?

How to load Data from a .txt file to Table Stored as ORC in Hive?

How to skip header rows from a table in Hive?

Create single Hive table for small files without degrading performance in Hive?

How will you consume this CSV file into the Hive warehouse using built SerDe?

Is it possible to change the default location of a managed table?

Can hive queries be executed from script files? How?

Can we run unix shell commands from hive? Give example?

Hands On Projects (2 Projects)

Installing Apache Zeppelin (0.10.1)

(Hands On) Downloading files

Data Files for the Project

(Hands On) Configure Hive Interpreter in Apache Zeppelin

Configure Hive Interpreter in Apache Zeppelin

Hadoop Configuration Setting

Download Source Code for Project

Source Code

Starting Hadoop,Hive, Zeppelin and Uploading Source Code

Project 1 Part 1

Project 1 Part 2

Project 1 Part 3

Project 1 Part 4

Project 1 Part 5

Project 2 Part 1

Project 2 Part 2

Project 2 Part 3

Project 2 Part 4

Project 2 Part 5

Project 2 Part 6

Preview - Apache Hive for Data Engineers (Hands On) with 2 Projects