Hive

  • Introduction
  • Hive Shell
  • Data Model and Data Types
  • HiveQL : Table Operations, LOAD, INSERT, SELECT, JOIN, ORDER BY, SORT BY
  • Operators and Built-in Functions and Subqueries
  • Partitions , Buckets, External Tables
  • User Defined Functions
  • Creating and Running scripts,Debugging and Performance Tuning
  • Lab Work

Pig

  • Introduction
  • Grunt
  • Data Model and Relations
  • Commands and Operators : GROUP,FILTER, JOIN , FOREACH, ORDER BY, LIMIT, COGROUP, FLATEN, SAMPLE, EXPLAIN
  • Structure Processing Flow
  • User Defined Functions
  • Creating and Running scripts, Debugging and Performance Tuning
  • Lab Work