Library

Course: Apache Hive - A Complete Guide

Apache Hive - A Complete Guide

  • Life Time Access
  • Certificate on Completion
  • Access on Android and iOS App
About this Course

Apache Hadoop EcoSystem Hive Concept course is basically intended for users who are interested to learn about Hive. Hive enables examination of huge data sets using a language. This means anyone who can write SQL queries can access data stored on the Hadoop cluster. This discussion introduces the functionality of Hive, as well as its various applications for data analysis and data warehousing. The course will give you proper understanding about Apache Hive concepts from basic till advance like what Hive is, hive data types, commands partitioning ,bucketing etc.

After this course student/professional will have complete knowledge about the topics with practical along with advance concepts and they would be able to work on Hive with full of confidence.

Who is the target audience?

  • Students ,Professionals, Anyone who wants to learn about data and analytics
Basic knowledge
  • Basic Computer Knowledge, Basic Database Knowledge, Experience of SQL/coding
What you will learn
  • Apache Hadoop EcoSystem Hive Concept course is basically intended for users who are interested to learn about Hive. Hive enables examination of huge data sets using a language. This means anyone who can write SQL queries can access data stored on the Hadoop cluster. This discussion introduces the functionality of Hive, as well as its various applications for data analysis and data warehousing. The course will give you proper understanding about Apache Hive concepts from basic till advance like what Hive is, hive data types, commands partitioning ,bucketing etc
Curriculum
Number of Lecture: 23
Total Duration: 05:04:33
Introduction
  • Introduction  
  • Overview of Hive continues  
  • Setup or Install Hive on Cloudera Windows  

    Understand how to set up/install hive on cloudera

  • Basics Command in Hive  

    Understand Basics Command in Hive


  • Understand and Demo on Managed table and External Table  

    Understand and Demo on Managed table and External Table

  • Comparison between MapReduce,PIG and Hive  

    Comparison between MapReduce, PIG and Hive

  • Understand Alter table statements in Hive  

    Understand Alter table statements in Hive

  • Understand Relational Operators in Hive  

    Understand Relational Operators in Hive

  • Understand Built-in Functions in Hive  

    Understand Built-in Functions in Hive

  • Understand and Demo on View in Hive  

    Understand and Demo on View in Hive

  • Understand and Demo on Index in Hive  

    Understand and Demo on Index in Hive

  • Understand and Demo on Joins in Hive  

    Understand and Demo on Joins in Hive

  • Understand and Demo on Complex Types in Hive  
  • Introduction on Sorting Types in Hive  

    Introduction on Sorting Types in Hive

  • Demo on Sorting Type Hive  

    Demo on Sorting Type Hive

  • Understand Partitioning in Hive  

    Understand Partitioning in Hive

  • Demo on Partitioning in Hive  

    Demo on Partitioning in Hive

  • Understand Bucketing in Hive  

    Understand Bucketing in Hive

  • Demo on Bucketing in Hive  

    Demo on Bucketing in Hive

  • Understand Process Json Data  

    Understand how to process Json Data in Hive

  • Understand Hive User Defined Functions (UDF's)  

    Understand Hive User Defined Functions (UDF's)

  • Demo on Hive UDF  

    Demo on Hive UDF

  • Conclusion  
Reviews (0)