What is differences between Apache Hive and RDBMS ?

What is differences between Apache Hive and RDBMS ?

Hive	RDBS
SQL  Interface	SQL  Interface
Focus  on  analytics	May  focus  on  online  or  analytics.
No  transactions.	Transactions  usually  supported.
Partition  adds,  no  random  INSERTs. In‐Place  updates  not  natively  supported   (but   are  possible).	Random  INSERT  and  UPDATE  supported.
Distributed  processing  via  map/reduce.	Distributed  processing  varies  by  vendor   (if  available).
Scales  to  hundreds  of  nodes	Seldom  scale  beyond  20  nodes
Built  for  commodity  hardware	Often  built  on  proprietary  hardware   (especially  when  scaling  out).
Low  cost  per  peta byte.	What’s  a  peta byte? J