Hive to ADVANCE Hive (Real time usage) :Hadoop querying tool
- Offered byUDEMY
Hive to ADVANCE Hive (Real time usage) :Hadoop querying tool at UDEMY Overview
Duration | 7 hours |
Total fee | ₹2,299 |
Mode of learning | Online |
Credential | Certificate |
Hive to ADVANCE Hive (Real time usage) :Hadoop querying tool at UDEMY Highlights
- Earn a certificate of completion from Udemy
- Learn from 37 downloadable resource
- Get full lifetime access of the course material
- Comes with 30 days money back guarantee
Hive to ADVANCE Hive (Real time usage) :Hadoop querying tool at UDEMY Course details
- For Student who wants to learn Basic Hive + ADVANCE HIVE (Real Project Oriented)
- For Software Engineers who wants to learn What and How Hive queries are used in Real time projects
- For Techies who wants to get knowledge of Real-time Use cases asked in Interviews
- Querying and managing large datasets that reside in distributed storage
- Learn Questions and Use cases asked in Interviews
- Data-sets and Hive queries are available in resources tab. This will save your typing efforts
- Strength of this course is ADVANCE HIVE which consists of those Hive areas that are actually used in Real-time projects
- Make yourself prepared to work on Real time Big data and Hive projects by learning Advance Hive from this course
- Enroll into this course and get end to end knowledge of Basic + ADVANCE Hive + Interview asked Use cases
- This course is very rare of its kind and includes even very thin details of Hive which are not available anywhere online
- In this course you will get to understand a step by step learning of very Basic Hive to Advance Hive (which is actually used in Real-time projects) like: Variables in Hive, Table properties of Hive, Custom Input Formatter, Map and Bucketed Joins, Advance functions in Hive, Compression techniques in Hive, Configuration settings of Hive, Working with Multiple tables in Hive, Loading Unstructured data in Hive
- This course is made keeping in mind the Real Implementation of Hive in Live Projects
Hive to ADVANCE Hive (Real time usage) :Hadoop querying tool at UDEMY Curriculum
Introduction (Theory)
Introduction to Hive
Announcement
Motivation of Hive
Sql vs Hive
Trailer- Working of Hive
Architecture of Hive
Hive Basic Commands
HADOOP AND HIVE INSTALLATION
Create databases
Table creation and loading data into it
Part 1
Table creation and loading data into it
Part 2
Internal vs External table- Explained
Create Tables
Insert statement
Multi insert statement (Advance)
Alter Table Schema
Sorting -- sort by, order by, distribute by, cluster by
Functions in Hive
Date and Mathematical functions
String functions
Split(), Substr(), instr() functions
Conditional statements
Explode and Lateral view ( Advance functions)
Rlike function (Advance)
Rank(), Dense_rank(), Row_number() (Advance)
Partitioning in Hive
What is Partitioning?
Static partitioning
Dynamic partitioning
Alter Partitioned Table and MSCK Repair command (Advance)
Bucketing in Hive
What is Bucketing?
Create Bucketed Table
Table sampling (Advance)
No_drop, Offline command (Advance)
Joins in HIve
Inner Joins on 2 Tables
Outer Joins on 2 Tables
Join 3 Tables in Hive
Memory Management & Optimization of Joins
Map Joins (Advance)
Hive to ADVANCE Hive (Real time usage) :Hadoop querying tool at UDEMY Entry Requirements
- Prerequisite: Basic Knowledge of Hadoop file system (HDFS)
- Basic Knowledge of SQL
- Not mentioned
Other courses offered by UDEMY
Student Forum
Anything you would want to ask experts?
ManagementBusiness AnalyticsData AnalysisHive to ADVANCE Hive (Real time usage) :Hadoop querying tool