Introduction to Apache Hive

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

Hive CLI 00:02:08

Beeline 00:02:50

HUE 00:02:28

JDBC 00:03:53

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