Buy and Download - OReilly Infinite Skills Introduction to Apache Hive Training Video

2015
O'Reilly Media / Infinite Skills
Tom Hanlon
1:45
English

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.

01. Introduction
0101 What Is Apache Hive And Who Uses It?
0102 About The Author
0103 What You Should Expect From This Video
02. Connecting To Hive
0201 Hive CLI
0202 Beeline
0203 HUE
0204 JDBC
03. Creating Tables And Loading Data
0301 Creating A Table
0302 Loading Data
0303 Hive Record Structure
0304 Hive Data Types
04. Manipulating Tables With HiveQL
0401 Select Statement - Part 1
0402 Select Statement - Part 2
0403 Inserting Data Into A Hive Table Using HiveQL
0404 Creating A Table Using HiveQL
05. Views And Partitions
0501 Creating And Using Views
0502 Creating And Using Partitions
06. Functions And Using Transform
0601 Built In Functions
0602 User Defined Functions
0603 Transforming Data With Custom Scripts
07. Hive Execution Engines
0701 Map Reduce
0702 Tez
0703 Spark
08. Conclusion
0801 Wrap Up