Please enable JavaScript.
Coggle requires JavaScript to display documents.
Hadoop 與 SQL 之差異 - Coggle Diagram
Hadoop 與 SQL 之差異
Structure
SQL
Schema on write
load something that meet datatype
HADOOP
Schema on read
apply the rule to the code
Methodology of data provide
SQL
2 phase commit methodology
must have complete consistency across all the nodes before release to user
HADOOP
eventual consistency methodology
provide user with immediate answer
How data store
SQL
store in a logical form with interrelated tables and defined columns.
HADOOP
the data is replicated across multiple nodes