Oreilly - Introduction to Apache Hive
by | Released October 2015 | ISBN: 9781771374804
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 TABLE IF NOT EXISTSs 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 TABLE IF NOT EXISTSs and load data in Hive, execute SQL queries, use user defined functions, and transform scripts. Show and hide more Publisher resources View/Submit Errata
- 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
Show and hide more
Coktum |
