Wednesday, October 10, 2018

Hadoop vs. SQL Comparison


Hadoop: Schema on Read
SQL: Schema on Write

Hadoop: Compressed files across multiple nodes in a cluster
SQL: relational databases and tables

On the event of a node failure
Hadoop: provide an immediate answer to the user, eventual consistency
SQL: hold up the entire response to the user, complete consistency -- two-phase commit

HIVE:
mimic SQL syntax to perform Hadoop

No comments:

Post a Comment

Most Recent Posts