ABOUT THE COURSEIn 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
COURSE OBJECTIVESUpon successful completion of the course, the learner will be able to :
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.
You can opt for the following courses once you comeplete your ongoing course
E-Box is a Technology Enabled Active Learning and
Assessment platform for technology and engineering
domains apart from the basic LMS components like
quizzes, assignments, lesson components.