What is HIVE
Hive is a data ware house system for Hadoop. It runs SQL like queries called HQL (Hive query language) which gets internally converted to map reduce jobs. Hive was developed by Facebook. Hive supports Data definition Language(DDL), Data Manipulation Language(DML) and user defined functions.
DDL: create table, create index, create views.
DML: Select, Where, group by, Join, Order By
UDF: User Defined Function UDAF: User Defined Aggregate Function UDTF: User Defined Table Function
What HIVE is not
Points to remember