Hive is an open source data warehouse which is initially developed by Facebook for analysis and querying datasets but is now under Apache software foundation.
Hive is developed on top of Hadoop as its data warehouse framework for querying and analysis of data is stored in HDFS.
Hive is useful for performing operations like data encapsulation, ad-hoc queries, & analysis of huge datasets. Hive's design reflects its targeted use as a system for managing and querying structured data.
HBase Vs Hive
|Data base model||Wide Column store||Relational DBMS|
|Data Schema||Schema- free||With Schema|
|SQL Support||No||Yes it uses HQL(Hive query language)|
|Consistency Level||Immediate Consistency||Eventual Consistency|
|Replication Methods||Selectable replication factor||Selectable replication factor|
HBase VS RDBMS
While comparing HBase with Traditional Relational databases, we have to take three key areas into consideration. Those are data model, data storage, and data diversity.