Difference between Hive and traditional Database

This is for Hadoop eco system like HDFS, Map reduce, Hive, Hbase, Pig, sqoop,sqoop2, Avro, solr, hcatalog, impala, Oozie, Zoo Keeper and Hadoop distribution like Cloudera, Hortonwork etc.
Posts: 81
Joined: Thu Jul 17, 2014 4:58 pm

Difference between Hive and traditional Database

Postby alpeshviranik » Wed Jul 23, 2014 2:39 am

What is the difference between Hive and Traditional database? What is Metastore in Hive?


Re: Difference between Hive and traditional Database

Postby Guest » Thu Jul 31, 2014 2:58 am

Difference between traditional database like SQL and HIveQL
    1) In SQL we have UPDATE, INSERT, DELETE while HiveQL INSERT OVERWRITE TABLE will populate data.
    2) Time Latency is faster in SQL then HiveQL
    3) Transactions and Indexes are supported in SQL but not supported HiveQL.
    4) Multitable inserts not supported in SQL while it supported in HiveQL
    5) So may built in unctions availbale in SQL where only few dozens functions available in HiveQL
    6) Corelated and noncorelated subquery supported in SQL while in HiveQL it supported only in From clause
    7) Join is supported with in SQL with multiple condition while in HiveQL it supported with few conditions
MetaStore in Hive
The MetaStore is a central repository for the Hive Metadata. It has service which run same JVM where HIve runs and the store of the data contains embedded derby database instance on local disk which called Embedded Metastore configuration.
Only one embedded derby database can access the database file on disk at any time. So yopu can open only one Hive session at a time.

Return to “Hadoop and Big Data”

Who is online

Users browsing this forum: No registered users and 2 guests