Learn Apache Hive and Start working with SQL queries which is on Data which is in Hadoop
What you’ll learn
- Install and Work on Hive
- Troubleshoot Hive Issues
- Partition and bucket data
- 64 Bit OS to download VM and work along with videos.
*** This is Course was Created 4 years back. New tutorials will be added based on requirements.***
This tutorial starts with an understanding need for hive Architecture and different configuration parameters in Hive. During this course, you will learn different aspects of Hive and how it fits as a data warehousing platform on Hadoop. Please subscribe to my Youtube Channel “Hadooparch” for more details.
This Course covers Hive, the SQL of Hadoop. (HQL) We will learn why and How Hive is installed and configured on Hadoop. We will cover the components and architecture of the Hive to see how it stores data in table-like structures over HDFS data. Understand the architecture, installation, and configuration of the Hive. We will install and configure Hive server2 and replace the PostgreSQL database with MySQL. we will also learn how to install MySQL and configure it as Hive Metastore
This Course is full of Hive demonstrations. We’ll cover how to create Databases, understand data types, create external, internal, and partitioned hive tables, bucketing load data from the local filesystem as well as the distributed filesystem (HDFS), setup dynamic partitioning, create views, and manage indexes and how different layers work together on Hive.
We will go through different roles in implementing in Real-time projects, how projects are set up and permissions, Auditing, Troubleshooting.
Finally, I will give sample data and queries to work and replicate what has been taught in Videos.
This Course has multiple questions to test your understanding. Kindly attempt all of them.
Who this course is for:
- Anyone with Basic understanding of Hadoop and basics of SQL
Direct Download [583 MB]