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 |
No comments:
Post a Comment