Video description
In this Introduction to Apache Hive training course, expert author Tom Hanlon will teach you how to create and query large datasets in Hadoop. This course is designed for the absolute beginner, meaning no experience with SQL or Hadoop is required.
You will start by learning how to connect to Hive, then jump into learning how to create tables and load data. From there, Tom will teach you how to manipulate tables with HiveQL, including how to insert data into a Hive table using HiveQL. This video tutorial also covers how to create views and partitions and transform data with custom scripts. Finally, you will learn about Hive execution engines, such as Map Reduce, Tez, and Spark.
Once you have completed this computer based training course, you will have learned how to create tables and load data in Hive, execute SQL queries, use user defined functions, and transform scripts.
Publisher resources
Table of contents
-
Introduction
- What Is Apache Hive And Who Uses It? 00:02:45
- About The Author 00:01:06
- What You Should Expect From This Video 00:01:59
- Connecting To Hive
-
Creating Tables And Loading Data
- Creating A Table 00:08:21
- Loading Data 00:02:40
- Hive Record Structure 00:08:09
- Hive Data Types 00:05:53
-
Manipulating Tables With HiveQL
- Select Statement - Part 1 00:08:02
- Select Statement - Part 2 00:04:53
- Inserting Data Into A Hive Table Using HiveQL 00:02:14
- Creating A Table Using HiveQL 00:01:44
-
Views And Partitions
- Creating And Using Views 00:02:29
- Creating And Using Partitions 00:04:16
-
Functions And Using Transform
- Built In Functions 00:03:46
- User Defined Functions 00:03:52
- Transforming Data With Custom Scripts 00:09:48
-
Hive Execution Engines
- Map Reduce 00:08:43
- Tez 00:05:29
- Spark 00:02:31
-
Conclusion
- Wrap Up 00:02:53
Product information
- Title: Introduction to Apache Hive
- Author(s):
- Release date: October 2015
- Publisher(s): Infinite Skills
- ISBN: 9781771374804
You might also like
book
Apache Hive Essentials
This book takes you on a fantastic journey to discover the attributes of big data using …
video
Introduction to Apache Kafka
Currently one of the hottest projects across the Hadoop ecosystem, Apache Kafka is a distributed, real-time …
video
Fundamentals of Apache Flink
Have you heard of Apache Flink, but don't know how to use it to get on …
video
Apache Kafka for Absolute Beginners
This course is designed to get you up and running with the fundamentals and the working …
