f

Master Hive Query language, Hive UDF and other concepts like Loading, Querying and Importing data in Hive.

  • 128K + satisfied learners. Reviews
Weekend $190
Weekdays

Training Features

Course Duration

You will undergo self-paced learning where you will get an in-depth knowledge of various concepts that will be covered in the course.


Real-life Case Studies

Towards the end of the Course, you will work on a real life case study.


Assignments

Each class has practical assignments which shall be finished before the next class and helps you to apply the concepts taught during 


Lifetime Access

You get lifetime access to Learning Management System (LMS) where presentations, quizzes, installation guide & class recordings are there.


Certification

Certpine certifies you as a Hive Expert based on the project reviewed by our expert panel.


Forum

We have a community forum for all our customers that further facilitates learning through peer interaction and knowledge 


Lifetime Access

You get lifetime access to Learning Management System (LMS) where presentations, quizzes, installation guide & class recordings are there.


Course Description

Project

For your practical work, you will setup Certpine's Virtual Machine in your System. This will be a local access for you. The required installation guide is present in LMS.

Project #1: Health & Hospital Management 

Industry: Healthcare 

Problem Statement: How many hospitals centres have more than 60% patient satisfaction with respect to cleanliness? Which hospital centre has the overall rating of either 9 or 10 

Project #2: Country Project 

Industry: Government 

Problem Statement: Sort the number of countries based on landmass. Find out the top 5 countries with sum of bars and strips in a flag. Count the number of countries with an icon in the flag. Count the number of countries which have the same colour in the top left and top right corners of their flag.

Curriculum

Learning Objectives - This module will help you in understanding concepts like Loading, Querying and Importing data in Hive.

Topics - Hive Background, Hive Use Case, About Hive, Hive vs Pig, Hive Architecture and Components, Meta-store in Hive, Limitations of Hive, Comparison with Traditional Database, Hive Data Types and Data Models, Partitions and Buckets, Hive Tables(Managed Tables and External Tables),Importing Data, Querying Data, Managing Outputs.

Learning Objectives - In this module you will learn more advanced concepts of Hive like the Hive querying language and Hive UDFs. 

Topics - Hive Script, Hive UDF and Hive Demo on Healthcare Data set. Hive QL: Joining Tables, Dynamic Partitioning, Custom MapReduce Scripts, Thrift Server, User Defined Functions.

FAQ's

To help you in this endeavor, we have added a resume builder tool in your LMS. Now, you will be able to create a winning resume in just 3 easy steps. You will have unlimited access to use these templates across different roles and designations. All you need to do is, log in to your LMS and click on the "create your resume" option.

All the instructors at Certpine are practitioners from the Industry with minimum 10-12 yrs of relevant IT experience. They are subject matter experts and are trained by Certpine for providing an awesome learning experience.

Just give us a CALL at +91 88808 62004 OR email at sales@certpine.co.US Toll free number is 1800 275 9730.

Certification