What is HIVE? Hive Provides Hive does NOT provide Hive versus java and pig Word Count Using HIVE? Sql Vs Hive Hive Vs Pig Hadoop MapReduce vs Pig vs Hive Hive Components HIVE Directory structure Hive Services CLI Hiveserver Hwi Metastore Hive Metastore Metastore configuration Embedded Local Remote Hive Clients Hive Concepts What is HIVE? Hive is a data warehouse system built on top of Hadoop. Hive provides a SQL interface, better known as HiveQL or HQL for short, which allows for easy querying of data in Hadoop. HQL has its own Data Definition and Data Manipulation languages which are very similar to the DML and DDL. Hive is not a full database. Early Hive development work started at Facebook in 2007 Today Hive is an Apache project under Hadoop –http://hive.apache.org DDL: create table, create index, create views. DML: Select, Where, group by, Join, Order By Plug...