This
course is for Big Data Testing with Hive Database. All the users who are working in QA profile and wanted to move into big data testing
domain should take this course and go through the complete
tutorials.
I have included the material which is needed for big data
testing profile and it has all the necessary contents which is required for
learning Hive database.
It will give the detailed information for Hive as database and
what all areas tester should be fulfilled with their knowledge to make
their career into Big Data Testing.
This course is well structured with all elements of Hive in
detailed manner separated by different topics. Students should take this course
for Hive learning.
Hive Contents Introduction
In this video, students would get the detailed information about all the contents which would be included in this Hive tutorial.
In this video, students would get the detailed information about Hive Overview and what kind of functionalities it includes.
Cloudera Environment Setup Process
Hive - Views and Indexes Implementation
In this session, students would get the detailed knowledge/information about the Views in Hive. They will get the information how it is implemented in real time projects.
In this session, students would get the detailed knowledge of Hive Indexes implementation with step by step information.
Different Type of Hive Partitions
In this session, students would get the detailed knowledge of different types of Hive Partitions and Static Partition implementation with step by step information.
In this session, students would get the detailed knowledge of dynamic Partition implementation with step by step information practically.
Other Hive Details
In this session, students would get the detailed knowledge of all the different modules/components of Hive.
In this session, students would get the detailed knowledge of Hive and SQL differences.
In this session, students would get the step by step information about the Hive Installation on Ubuntu machine.
In this session, students would get the knowledge of the Hive characteristics and features in detail.
Bucketing in Hive
In this session, students would get the detailed knowledge on how students implement the Bucketing in Hive and how to query the using this and verify the different buckets created on Hive table in real projects.
Different Types of Hive Tables and Its implementation
In this session, students get the knowledge of different type of Hive and there differences in detail.
In this session, students would get the knowledge of different types of Joins available in Hive and how it is created and implemented practically.
In this session, students would get the practical implementation knowledge of Managed Hive table i.e. default table in Hive.
In this session, students would get the practical implementation knowledge of External Hive table.
In this session, students would get the knowledge of different Hive queries i.e. create table, insert values in tables, drop table etc. in detail.
How to Implement Hive UDFs
In this session, students would get the detailed step by step information about UDF implementation in Hive and how it could be query through Hive CLI.
Hive Use Case Example
In this session, students get the practical knowledge of the Movielens Use Case for Hive that has several queries implementation in detailed manner.
In this session, students get the practical knowledge of the Movielens Use Case for Hive that has several queries implementation in detailed manner.
How to Update and Delete Records In Hive Table
In this session, students gets the detailed knowledge of the update and delete query implementation as they directly not available to use.
In this session, students get the knowledge of the add column feature that is used when they wanted to add/increase the columns in there table.
In this session, students get the knowledge of the inbuilt function used in query i.e. Min, Max, Avg and Count function used in hive table column.
In this session, students would get the information about the adding new tables from existing tables available in database practically.
In this session, students get the knowledge of the inbuilt function used in query for updating the table name i.e. renaming the table.
In this session, students get the knowledge of the inbuilt function used in query to replace existing column schema with new column schema for which Replace inbuilt function used in hive table.
Hive Collections
In this session, students would get the detailed implementation for the insert into and insert overwrite query implementation and its difference.