Excellent course material with demos
Advance Big Data Analytics using Hive & Sqoop
Become Big data Analyst using Hive and Sqoop.Great course for business Analyst,Testers and Sql Developers.CCA159
Updated on Sep, 2023
Language - English
You will start by learning what is Hadoop & Hadoop distributed file system and most common hadoop commands required to work with 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]
External & Managed Tables
Insert & Multi Insert
Data Types & Complex Data Types
Hive String Functions
Hive Date Functions
Joins, Multi Joins & Map Joins
Working with Different Files - Parquet,Avro
Windowing Functions - Rank/Dense Rank/lead/lag/min/max
Who this course is for:
- Who are preparing for CCA159 Cloudera Big Data Analytics Certification or who wants to learn Advance Hive & Sqoop
What will you learn in this course:
- Students will learn Advance Hive and Sqoop for Big Data Analytics and Ingestion.
What are the prerequisites for this course?
- Basic Knowledge of SQL
Check out the detailed breakdown of what’s inside the course
- 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 Data Types
Working with Different File Formats & Compressions
Hive Windows Function
Navdeep KaurTechnoAvengers.com (Founder)
I am a big data architect with 11 years of industry experience in different technologies and domains. I have keen interest in providing training in new technologies. I have received CCA175 Hadoop and Spark developer certification and Â AWS solution architect certification. I love guiding people and helping them achieve new goals.
User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.
Our students work
with the Best
Video is missing for HIVE PARTITIONING in Advance hive section. It is the same as VIEWS IN HIVE. Please fix this and kindly reply... I have already wrote couple of emails but no response.
Related Video CoursesView More
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video CoursesSubscribe now
Master prominent technologies at full length and become a valued certified professional.Explore Now