In this course, we will discuss the Hive data storage principle, performing operations with data in Hive, implementing Advance Query features of the Hive, the File formats and Record formats supported by the Hive environment Use Pig to automate the design and implementation of MapReduce applications
Upon successful completion of the course, the learner will be able to
Create data processing pipelines with Pig
Create and query a Big Data warehouse with Hive
What is Hive? Architecture & Modes / Hive installation In this module, you will be exposed to an overview of the role of Hive, architecture of Hive and how to install and configure Hive.
Hive Data Types / Create, Alter & Drop Table In this module, you will be exposed to various data types in Hive, how to create and drop a database in Hive, data modelling in Hive, various DDL commands with examples.
Hive Partitions & Buckets In this module, you will be exposed to Partitioning and Bucketing data model in Hive.
Hive Indexes and Views In this module, you will be exposed on how to create Hive Index and Hive Views, manage views and Indexing of Hive, Hive index types, Hive index performance, and Hive view performance.
Hive Queries: Order By, Group By, Distribute By, Cluster / Join & SubQuery In this module, you will be exposed to various clauses like order by, group by, sort by, cluster by and distribute by. And you will be exposed to different types of joins in Hive and steps to write subqueries with examples.
HiveQL: Built-in Operators In this module, you will be exposed to various Hive built-in operators.
Hive Function: Built-in & UDF (User Defined Functions) In this module, you will be exposed to various built-in functions in Hive. And you will be exposed to UDF(User Defined Functions).
Hive ETL: Loading JSON, XML, Text Data Examples In this module, you will be exposed to Introduction about Hive as ETL, Working with Structured Data using Hive, Working with Semi structured data using Hive and Hive in Real time projects.
What is Pig? Pig Architecture / How to download and install Pig In this module, you will be exposed to Apache Pig and its features, various components in Pig Architecture and how to install and configure Pig.
Pig Script In this module, you will be exposed to Pig Scripting with examples.
Learning through E-Box is completely Hands-on and practice based thereby helping you understand the intricacies of Live Project Scenarios
E-Box’s programs and Courses are designed by Professionals in the Industry & Academicians, assuring a quality learning experience
With 100’s Mentors online ready to get your Doubts clarified and to Hand Hold you, you will always have someone to sort things our for you
All our Mentors are Top Professionals from their respective Industries. In E-Box you Learn and get mentored by professionals
Auto Evaluation is the Core of E-Box. Your solutions and answers are evaluated instantaneously by E-Box, thereby saving learners a lot of time
With Auto - Evaluation being the core of the Platform, E-Box uses AI & ML to assist Learners during their course of Study
E-Box’s AI algorithms provide you with Exercises that are Personalised and Adaptive based on your Interest and Calibre
Data becomes the core for evolving a personalised learning. E-Box uses these metrics for an Auto Corrective Learning Process