HIVE VS RDBMS

Hive
+++++
— Large datasets
— parallel computation
— High latency
— read operation
— HIVEQL
— schema on read, no constraints
— minimal index supported
— Row level updates,deletes as a special case
— Many more build-in functions
— equi-joins allowed
— restricted subqueries
RDBMS
++++++
— small datasets
— serial computation
— low latency
— read/write operation
— SQL
— schema on write, not null and unique all enforced
— indexes allowed
— Row level operations allowed in general
— Basic build-in functions
— No restriction on joins
— whole rabge of subquries