Comprehensive Hive Certification Training

  • Overview
  • Course Content
  • Drop us a Query

Understanding the Hive technology can lead the professionals towards achieving their career goals in dealing with the Database management. Focusing on the importance of Hive, it is an essential tool that helps the professionals to manage as well as control Big Data with ease. Moreover, Hive brings the property of structuredness to Big Data when implemented in Hadoop and that is the reason Comprehensive Hive is one of the highly sought after courses by professionals, who are looking to gain expertise in Hadoop.

It is an Open-source, peta-byte scale Data Warehousing framework based on Hadoop. Nowadays, this is very much in demand as it is very helpful in Database management to manage Big Data.

The Comprehensive Hive Training course helps the candidates in

  • Developing the understanding the benefits of Hive and HiveQL 
  • It helps the candidates to perform the Data Analysis using Hive 
  • Helps in understanding the Hive querying language and Hive UDFs
  • Helps in understanding the concepts such as: Loading, Querying and Importing data in Hive
  • Helps to develop a better understanding of using Hadoop.
Target audience
  • Testing Professionals
  • Mainframe Professionals
  • BI /ETL/DW Professionals
  • Project Managers
  • Analytics Professionals
  • Graduates aiming to build a career in Big Data and Hadoop
Prerequisites

The candidates should have: 

  • An understanding of Linux commands and SQL Queries
  • Basic knowledge of core JAVA will be helpful to work on UDF

1. Introduction to Hive

  • What is Big data
  • What is Apache Hadoop
  • HDFS in Hadoop
  • Data Processing Framework In Hadoop
  • Hive Use cases @ Twitter
  • Hive vs Mapreduce
  • What is Hive
  • Advantages of hive
  • Hive Architecture

2. Hive Data Types and DDL

  • Hive Data Types
  • Hive QL
  • DDL on Databases
  • DDL on Tables
  • Different Tables in Hive
  • Different Tables in Hive Contd
  • Advanced DDL on tables
  • File Formats in Hive

3. Hive DML and HiveQL

  • DML - Loading Data in tables
    Managing Output
    Hive QL Queries
  • Operators and Functions in hive
  • Hive Clauses

4. Hive Queries and Views

  • Joins in Hive
  • Wordcount Example using Hive
  • Hive View
  • Clauses in Hive

5. Hive Indexing and Tuning

  • Hive Indexing
  • Indexing with Additional Properties
  • Tuning
  • Executive Hive Queries in Different Modes
  • Hadoop Tuning Parameters

6. Compression with Hive

  • Compression with Hive
  • Choosing a compression codec
  • Sequence Files
  • Sequence Files with Different Compression Types
  • Running Compression with Hive Queries

7. UDFs in Hive

  • Functions in Hive
  • Aggregation, Calling, table generating Functions
  • Different Kinds of UDFs
  • Creating and Calling UDFs in Hive
  • Hive UDAFs

8. Customizing Hive File and Record Formats

  • TextFile and Sequence File Formats
  • RCFile Format
  • CSV and JSON SerDe
  • Hive Avro SerDe

9. Hive Storage Handlers and NoSQL

  • Hive Storage Handlers
  • HBase

A Few Things You'll Love!

What our Students Speak

+