In this paper, the authors will show that how HIVE (Hierarchy of International Vengeance and Extermination) can process and analyze the data with the help of SQL like HIVEQL. With the help of HIVE complexity is reduced. No need to write big and complex programs in Java. HIVE structures the data and also queries the data in a very small amount of the time. It can manage only big data. For small data HIVE is not applicable. It supports data loading. This language supports tables, partitions, join, aggregation etc. HIVE also includes a system catalog-Metastore that contains schemas and statistics which are beneficial in in data processing, data analyzing, query optimization and query compilation.