Difference between Hive and Oracle

1. Hive :
Hive is an open-source data warehouse software. It is built on the top of Hadoop. It also provides HiveQL which is similar to SQL. Hive is used for querying and managing distributed datasets built on Hadoop. Hive uses RDBMS as a primary database model.

2. Oracle :
Oracle is commercial software developed by Oracle Corporation. Oracle widely uses RDBMS. It is used for running Online Transaction Processing and Data Warehousing. Oracle runs on the most major operating systems like Mac OS, UNIX, Windows and Linux. Oracle has a networking stack, allows applications from a different platform to communicate with the Oracle easily.

Difference between Hive and Oracle :

S.NO. Hive Oracle
1. It is developed by Apache Software Foundation. It is developed by Oracle Corporation.
2. It was launched in 2012. It was launched in 1980.
3. It is implemented in Java. It is implemented in C and C++.
4. It uses Sharding partitioning method for storing different data on different nodes. It uses Horizontal partitioning method for storing different data on different nodes.
5. There are no transaction concepts. ACID properties of transaction are used.
6. No concept of referential integrity and no Foreign keys. Referential integrity is used in Oracle.
7. It is an open-source software. It is a commercial software.
8. Eventual Consistency method ensures consistency in a distributed system. Immediate Consistency method ensures consistency.
9. It offers API for user-defined Map/Reduce methods. It does not offer any API for user-defined Map/Reduce methods.
10. JDBC, ODBC, Thrift are the APIs and access methods used in Hive. DBC, ODBC, ODP.NET, OCI are the APIs and access methods used in Oracle.

Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.

My Personal Notes arrow_drop_up

Check out this Author's contributed articles.

If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.

Article Tags :
Practice Tags :


Please write to us at contribute@geeksforgeeks.org to report any issue with the above content.