RDBMS vs Hadooop vs NOSQL

RDBMS

interactive & batch
many read/write
static schema


Hadooop

batch ( spark and many libraries help interactive though)
write once / read many times
schema on read
Scale out

NoSQL
eventual consistency.