Thursday, May 21, 2015

HIVE Vs RDBMS

       
HIVE
RDBMS
·         Hive is a data warehouse which provides SQL like queries for data residing in HDFS. A RDBMS wrapper for files available in HDFS.
·         Hive is strictly used for select. NO UPDATE/DELETE is provided. It makes it a data warehouse. The SQL code written in Hive eventually turns into MapReduce code and is implemented on database.
·         And also RDBMS uses SQL, PL/SQL and relational calculus for execution on data set
·         RDMBSs are schema-on write
·         RDBMS is structured data which store data's in the form of tables and we use SQL to retrive data.

·         RDBMS as said my Vigneshwara is structured database used in traditional databases for the OLTP and OLAP purpose.


·         HIVE only SQL is used


·         Hive is schema-on read

No comments:

Post a Comment