What is difference between RDBMS vs Hive

TG
7:30:45 PM
Lets talk about  RDBMS  and  HIVE system.

RDBMS A relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as invented by E. F. Codd.

 Hive Apache Hive is a data warehouse infrastructure built on top of Hadoop for providing data summarization, query, and analysis.


          RDBMS           Hive
Language
SQL-92 standard

Subset of SQL-92 plus
Hive-specific extensions
Update Capabilities
INSERT, UPDATE, and
DELETE
INSERT OVERWRITE
and INSERT INTO;
no UPDATE or DELETE
Transactions
Yes
No
Latency
Sub-second
Minutes or more
Indexes
Any number of indexes,
very important for
performance
No indexes, data is
always scanned (in
parallel)*
Data size
TBs
PBs
Scalbility
Not much Scalable, costly scale up.It’s very easily scalable at low cost