HIVE
Duration: 2 Days
Pre-requisite:
• Knowledge of SQL, data modeling, and scripting is also helpful. No prior Hadoop Knowledge
is needed
Hadoop Distributed File System (HDFS)
• HDFS overview and design
• HDFS architecture
• HDFS file storage
• Component failures and recoveries
• Block placement
Map-Reduce Abstraction
• What MapReduce is and why it is popular
• The Big Picture of the MapReduce
• MapReduce process and terminology
• MapReduce components failures and recoveries
• Working with MapReduce
• Lab: Working with MapReduce
Hive
Overview of Hive
v Why Hive?
v Use cases
v Hive architecture – building blocks
v Hive CLI and language (exercise)
v Variables and Properties
v Executing Hive Queries from Files
v Primitive Data Types
v Collection Data Types
v Difference between HivelQL and SQL92
v Custom UDF
HiveQL Queries
