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

For your practical work, you will setup CertAdda’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.

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 CertAdda are practitioners from the Industry with minimum 10-12 yrs of relevant IT experience. They are subject matter experts and are trained by CertAdda for providing an awesome learning experience.

Just give us a CALL at +91 8178510474 / +91 9967920486 OR email at admin@certadda.com