Hive to ADVANCE Hive Real time usage Hadoop querying tool
What you’ll learn
Learn Full In and out of Apache HIVE (From Basic to Advance level).
Strength of this course is ADVANCE HIVE which consists of those Hive areas that are actually used in Real-time projects.
Querying and managing large datasets that reside in distributed storage using Hive.
Learn Interviews asked Questions and Use cases.
Data-sets and Hive queries are available in resources tab.
Requirements
Basic Knowledge of Hadoop file system (HDFS)
Basic Knowledge of SQL
Rest everything is covered in this course (Hive + Advance Hive)
Description
Apache Hive is a data processing tool on Hadoop. It is a querying tool for HDFS and the syntax of it’s queries is almost similar to our old SQL. Hive is an open source-software that lets programmers analyze large data sets on Hadoop.Benefits of this course:”Basic Hive is not sufficient if you want to work on 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 HiveCustom Input FormatterMap and Bucketed JoinsAdvance functions in HiveCompression techniques in Hive Configuration settings of HiveWorking with Multiple tables in HiveLoading Unstructured data in HiveAnd many more……This course is a full package explaining even rarely used commands and concepts in Hive. After completing this course you won’t find any topic left in Hive. This course is made keeping in mind the Real Implementation of Hive in Live Projects.Apart from this I have included 1 more section which is Use cases asked in Interviews. Usually students can answer the direct questions asked by Interviewers but got stuck on Use cases . For that I have explained the frequently asked Use cases with their proper practical working in Hive. Additionally ,You can download the Step Step Installation Guide (pdf) to Install Hadoop and Apache Hive
Overview
Section 1: Introduction (Theory)
Lecture 1 Introduction to Hive
Lecture 2 Announcement
Lecture 3 Motivation of Hive
Lecture 4 Sql vs Hive
Lecture 5 Trailer- Working of Hive
Lecture 6 Architecture of Hive
Section 2: Hive Basic Commands
Lecture 7 HADOOP AND HIVE INSTALLATION
Lecture 8 Create databases
Lecture 9 Table creation and loading data into it |Part 1
Lecture 10 Table creation and loading data into it |Part 2
Lecture 11 Internal vs External table- Explained
Lecture 12 Insert statement
Lecture 13 Multi insert statement (Advance)
Lecture 14 Alter Table Schema
Lecture 15 Sorting — sort by, order by, distribute by, cluster by
Section 3: Functions in Hive
Lecture 16 Date and Mathematical functions
Lecture 17 String functions
Lecture 18 Split(), Substr(), instr() functions
Lecture 19 Conditional statements
Lecture 20 Explode and Lateral view ( Advance functions)
Lecture 21 Rlike function (Advance)
Lecture 22 Rank(), Dense_rank(), Row_number() (Advance)
Section 4: Partitioning in Hive
Lecture 23 What is Partitioning?
Lecture 24 Static partitioning
Lecture 25 Dynamic partitioning
Lecture 26 Alter Partitioned Table and MSCK Repair command (Advance)
Section 5: Bucketing in Hive
Lecture 27 What is Bucketing?
Lecture 28 Create Bucketed Table
Lecture 29 Tablesampling (Advance)
Lecture 30 No_drop, Offline command (Advance)
Section 6: Joins in Hive
Lecture 31 Inner Joins on 2 Tables
Lecture 32 Outer Joins on 2 Tables
Lecture 33 Join 3 Tables in Hive
Lecture 34 Memory Management & Optimization of Joins
Lecture 35 Map Joins (Advance)
Section 7: Views in Hive
Lecture 36 What are views?
Lecture 37 Creating Views in different ways
Lecture 38 Advantages of Views
Section 8: Indexing (Advance)
Lecture 39 Creation of Indexes (Compact and Bitmap)
Lecture 40 Multiple Indexes on same table
Lecture 41 When and When not to use Indexing
Section 9: UDF’s (User defined functions) Advance
Lecture 42 What is UDF
Lecture 43 UDF Implementation – Practical
Section 10: Table Properties (Advance)
Lecture 44 Skipping Header and Footer records while loading in table
Lecture 45 Immutable Table property
Lecture 46 Purge property + Difference between Drop and Truncate
Lecture 47 Null Format property
Lecture 48 ACID/Transactional features of Hive ( Advance)
Lecture 49 ORC Table properties
Section 11: Configurations & Settings in Hive (Advance)
Lecture 50 Part 1
Lecture 51 Part 2
Lecture 52 Merge files in Hive
Lecture 53 Parallelism Property
Section 12: Variables in Hive (Advance)
Lecture 54 Executing Hive queries from Bash shell
Lecture 55 Run Unix & Hadoop commands from Hive Shell
Lecture 56 Variables in Hive (hiveconf & hivevar)
Lecture 57 Difference between hiveconf & hivevar
Lecture 58 Using variables in bash shell
Lecture 59 Substituting value of a Variable
Section 13: Different Types of Files in Hadoop
Lecture 60 Text, Sequence, Avro Files
Lecture 61 RC, ORC, Parquet Files
Lecture 62 Performance Test results of Various Files
Lecture 63 Which File Format to choose
Section 14: Custom Input Fomatter (Advance)
Lecture 64 Using Custom Input Format in Hive
Section 15: Miscellaneous (Advance)
Lecture 65 Modes of Hive
Lecture 66 Compression techniques in Hive
Lecture 67 Hiverc file (Creation and Uses)
Lecture 68 Archiving files in Hive
Section 16: TEZ engine in Hive
Lecture 69 What is Tez engine and its comparison with MR
Section 17: Load XML data in Hive
Lecture 70 How to Load XML data in Hive tables– Part1
Lecture 71 How to Load XML data in Hive tables– Part2
Section 18: Implementing SCD’s in Hive (Advance)
Lecture 72 What is Slowly changing Dimension (SCD)
Lecture 73 Implement SCD 1 in Hive–part1
Lecture 74 Implement SCD 1 in Hive–part2
Section 19: Use Cases asked in Interviews
Lecture 75 Word count in Hive
Lecture 76 Multiple Tables on a single file
Student who wants to learn Basic Hive + ADVANCE HIVE (Real Project Oriented).,Software Engineers who want to learn What and How Hive queries are used in Real time projects.,Techies who wants to get knowledge of Real-time Hive Use cases asked in Interviews.
Course Information:
Udemy | English | 6h 58m | 2.18 GB
Created by: J Garg
You Can See More Courses in the IT & Software >> Greetings from CourseDown.com