Big Data Analytics with Hive, Pig & MapReduce
Keep adding new skills with 10,000+ programs for $239 (usually $399). Save now.
Big Data Analytics with Hive, Pig & MapReduce
This course is part of Hadoop Big Data Analytics & Projects Mastery Specialization
Included with
Ask Coursera
What you'll learn
Design and optimize Hive databases for large datasets.
Process XML data and execute MapReduce and Pig scripts.
Apply analytics to real-world telecom and social data.
Skills you'll gain
Details to know
See how employees at top companies are mastering in-demand skills
Build your subject-matter expertise
- Learn new concepts from industry experts
- Gain a foundational understanding of a subject or tool
- Develop job-relevant skills with hands-on projects
- Earn a shareable career certificate
There are 4 modules in this course
By the end of this course, learners will be able to design Hive databases, manage complex tables, process XML data with Pig, execute MapReduce jobs, and analyze large-scale social media datasets to extract meaningful insights. The course begins with foundational concepts of Hive, including databases, partitions, and bucketing, then advances into table optimization and constraints for schema design. Learners will gain practical experience in ingesting data with Sqoop, processing it using MapReduce, and applying location- and author-based analytics to real-world datasets. Finally, the course explores Pig scripting for XML processing and Hive complex data types for advanced bookmarking dataset analysis.
This course is unique because it combines two hands-on case studies: one from the telecom industry and another from social media analytics, offering a blend of foundational Hive knowledge and advanced Hadoop ecosystem tools. Designed for professionals, students, and data enthusiasts, the course emphasizes practical application over theory, ensuring learners can confidently apply big data technologies to solve real business problems.
This module introduces Apache Hive and its role in the Hadoop ecosystem. Learners will explore Hive’s basic features, database commands, table operations, and foundational concepts like external tables, partitions, and bucketing. By the end, they will have a strong foundation to query and manage data effectively in Hadoop using Hive.
What's included
10 videos4 assignments
10 videos•Total 65 minutes
- Introduction of Hive•8 minutes
- Simple and Complex Datatype in Hive•9 minutes
- Clusters•0 minutes
- Database Command in Hive•12 minutes
- Tables Commands in Hive•6 minutes
- Manage Tables•6 minutes
- External Tables•2 minutes
- Introduction to Partitioning•7 minutes
- Partition Command•7 minutes
- Bucketing•8 minutes
4 assignments•Total 60 minutes
- Foundations of Hive and Big Data•30 minutes
- Getting Started with Hive•10 minutes
- Hive Database Essentials•10 minutes
- Advanced Table Management in Hive•10 minutes
This module dives deeper into advanced Hive functionality, including table constraints and complex table creation. Learners will understand how to design optimized tables and implement constraints to improve schema structure and maintainability in Hive.
What's included
4 videos3 assignments
4 videos•Total 33 minutes
- Table Contr Services in Hive•11 minutes
- Example of Contr Services•7 minutes
- Example of Contr Services Continues•5 minutes
- Creating Contract All Table•11 minutes
3 assignments•Total 50 minutes
- Optimizing Data with Hive•30 minutes
- Hive Constraints in Action•10 minutes
- Creating Advanced Tables•10 minutes
This module focuses on importing social media data into Hadoop, processing it with MapReduce, and analyzing it for insights. Learners will practice using Sqoop for RDBMS to HDFS transfers, run MapReduce programs, and analyze datasets by location, authors, and reader preferences.
What's included
11 videos4 assignments
11 videos•Total 90 minutes
- Introduction to Social Media Industry•9 minutes
- Book Marking Website•8 minutes
- Book Marking Website Continues•5 minutes
- Understanding Sqoop•7 minutes
- Get Data from RDMS to HDFS•9 minutes
- Execute Map Reduce Program in order to Process XML File•12 minutes
- Analyze Book Performance By Reviews Using Code•7 minutes
- Analyze Book Performance By Reviews Using Code Continues•9 minutes
- Analyse Book By Location•7 minutes
- Example of Analyse Book By Location•7 minutes
- Analyse Book Reader Against Author•10 minutes
4 assignments•Total 60 minutes
- Social Media Data Integration and Processing•30 minutes
- Social Media Landscape and Data Ingestion•10 minutes
- Processing Data with MapReduce•10 minutes
- Location and Reader Analysis•10 minutes
This module explores Pig and Hive for advanced social media analytics. Learners will process XML data with Pig, store and explore outputs, and utilize Hive complex data types with MapReduce for deep insights into bookmarking datasets and user interactions.
What's included
12 videos4 assignments
12 videos•Total 112 minutes
- How to process XML File in PIG•6 minutes
- How to process XML File in PIG Continues•8 minutes
- Analyze Book Performance in XML File in PIG•10 minutes
- More on Analyze Book Performance in XML File in PIG•10 minutes
- Pig XML File Output Using Book•9 minutes
- Pig XML File Output Using Location•10 minutes
- Pig XML File Output Using Location Continues•9 minutes
- Understanding Complex Data Set Using Hive•12 minutes
- Understanding Complex Data Set Using Hive Continues•10 minutes
- Create Array in Map Reduce Using Hive•10 minutes
- Book Marking Type Data Set Using Complex Type•9 minutes
- Output of Book Marking Type Data Set•10 minutes
4 assignments•Total 60 minutes
- Social Media Insights with Pig and Hive•30 minutes
- XML Data Processing with Pig•10 minutes
- Pig Outputs and Data Exploration•10 minutes
- Complex Data Structures with Hive and MapReduce•10 minutes
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.
Explore more from Data Analysis
- Status: Free Trial
Course
- Status: Free Trial
Course
- Status: Free Trial
Course
- Status: Free Trial
Course
Why people choose Coursera for their career
Frequently asked questions
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.
More questions
Financial aid available,