Excellent course material with demos
Advance Big Data Analytics using Hive & Sqoop
Become Big data Analyst using Hive and Sqoop. Great course for Business Analysts, Testers and SQL Developers.
Lectures -51
Resources -6
Duration -4 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
You will start by learning what is Hadoop & Hadoop distributed file system and the most common Hadoop commands required to work with the Hadoop File system
Then you will be introduced to Sqoop Import
Understand lifecycle of sqoop command.
Use sqoop import command to migrate data from Mysql to HDFS.
Use sqoop import command to migrate data from Mysql to Hive.
Use various file formats, compressions, file delimeter, where clause, and queries while importing the data.
Understand split-by and boundary queries.
Use incremental mode to migrate the data from Mysql to HDFS.
Further, you will learn Sqoop Export to migrate data.
What is sqoop export
Using sqoop export, migrate data from HDFS to Mysql.
Using sqoop export, migrate data from Hive to Mysql.
Finally, we will start with Apache Hive [Advance]
Hive Intro
External & Managed Tables
Insert & Multi Insert
Data Types & Complex Data Types
Collection Function
Conditional Function
Hive String Functions
Hive Date Functions
Mathematical Function
Hive Analysis
Alter Command
Joins, Multi Joins & Map Joins
Working with Different Files - Parquet, Avro
Compressions
Partitioning
Bucketing
Views
Lateral Views/Explode
Windowing Functions - Rank/Dense Rank/lead/lag/min/max
Window Specification
Who this course is for:
- Who are preparing for CCA159 Cloudera Big Data Analytics Certification or who wants to learn Advance Hive & Sqoop
Goals
- Students will learn Advance Hive and Sqoop for Big Data Analytics and Ingestion.
Prerequisites
- Basic Knowledge of SQL
Curriculum
Check out the detailed breakdown of what’s inside the course
Hadoop Introduction
5 Lectures
-
Big Data Intro 05:24 05:24
-
Hadoop Distributed File System & Commands 09:16 09:16
-
Cloudera vm setup
-
Cluster Setup on Google Cloud 19:13 19:13
-
MapReduce Overview 07:41 07:41
Hive
6 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Hive Data Types
4 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Hive Functions
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Hive Join
3 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Working with Different File Formats & Compressions
3 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Advance Hive
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Hive Windows Function
4 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Sqoop Import
13 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Sqoop Export
2 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Instructor Details
![Navdeep Kaur](https://www.tutorialspoint.com/assets/profiles/136715/profile/200_40521-1610166267.jpg)
Navdeep Kaur
Navdeep is one of the renowned Premium Instructor at Tutorialspoint. Navdeep has 14 years of industry experience in different technologies and domains. With 9+ courses and 60,000+ students and rating of 4.5*, she is one of the leading instructors in the field of Big Data & Cloud.
Happy Learning!
Course Certificate
Use your certificate to make a career change or to advance in your current career.
![sample Tutorialspoint certificate](/market/public/assets/newDesign/img/primePacks/V-certificate.png)
Our students work
with the Best
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfc bank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfcbank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
Feedbacks
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now![Annual Membership Annual Membership](/market/public/assets/newDesign/img/membership-large-small.jpg)
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now![Online Certifications Online Certifications](/market/public/assets/newDesign/img/traning-for-a-team.png)