Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

Apache Hive

( Duration: 4 Days )

This Apache Hive training course is designed for analysts and developers who need to create and analyze Big Data stored in Apache Hadoop using Hive.

By attending Apache Hive workshop, delegates will learn:

  • Understanding of HDP and HDF and their integration with Hive
  • Hive on Tez, LLAP, and Druid OLAP query analysis
  • Hive data ingestion using HDF and Spark
  • Enterprise Data Warehouse offload capabilities in HDP using Hive

  • Familiar with programming principles and have experience in software development.
  • Knowledge of SQL, data modeling, and scripting is also helpful.
  • No prior Hadoop Knowledge is needed.

COURSE AGENDA

1

Information Architecture and Big Data

  • Enterprise Data Warehouse Optimization
2

Introduction to Apache Hive

  • About Apache Hive
  • About Apache Zeppelin and Apache Superset (incubating)
3

Apache Hive Architecture

  • Apache Hive Architecture
4

Apache Hive Programming

  • Apache Hive Basics
  • Apache Hive Transactions (Hive ACID)
5

File Formats

  • SerDes and File Formats
6

Partitions and Bucketing

  • Partitions
  • Bucketing
  • Skew and Temporary Tables
7

Advanced Apache Hive Programming

  • Data Sorting
  • Apache Hive User Defined Functions (UDFs)
  • Subqueries and Views
  • Joins
  • Windowing and Grouping
  • Other Topics
8

Apache Hive Performance Tuning

  • Cost-Based Optimization and Statistics
  • Bloom Filters
  • Execution and Resource Plans
9

Live Long and Process (LLAP) Deep Dive

  • Live Long and Process Overview
  • Apache Hive and LLAP Performance
  • Apache Hive and LLAP Installation
10

Security and Data Governance

  • Apache Ranger
  • Apache Ranger and Hive
  • Apache Atlas
  • Apache Atlas and Hive Integration
11

Apache HBase and Phoenix Integration with Hive

  • Apache HBase Overview
  • Apache HBase Integration with Apache Hive
  • Apache Phoenix Overview
12

Apache Druid (incubating) with Apache Hive

  • Apache Druid (incubating) Overview
  • Apache Druid (incubating) Queries
  • Apache Druid (incubating) and Hive Integration
13

Apache Sqoop and Integration with Apache Hive

  • Overview of Apache Sqoop
14

Apache Spark and Integration with Apache Hive

  • Introduction to Apache Spark
  • Apache Hive and Spark
15

Introduction to HDF (Apache NiFi) and Integration with Apache Hive

  • Introduction to Apache NiFi
  • Apache NiFi and Apache Hive

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top
Notice
X