A. Hive Introduction
Understanding Hive, traditional database comparison with Hive, Pig and Hive comparison, storing data in Hive and Hive schema, Hive interaction and various use cases of Hive
B. Hive for relational data analysis
Understanding HiveQL, basic syntax, the various tables and databases, data types, data set joining, various built-in functions, deploying Hive queries on scripts, shell and Hue.
C. Data management with Hive
The various databases, creation of databases, data formats in Hive, data modeling, Hive-managed Tables, self-managed Tables, data loading, changing databases and Tables, query simplification with Views, result storing of queries, data access control, managing data with Hive, Hive Metastore and Thrift server.
D. Optimization of Hive
Learning performance of query, data indexing, partitioning and bucketing
E. Extending Hive
Deploying user defined functions for extending Hive
F. Hands on Exercises – working with large data sets and extensive querying
Deploying Hive for huge volumes of data sets and large amounts of querying
G. UDF, query optimization
Working extensively with User Defined Queries, learning how to optimize queries, various methods to do performance tuning.