Search code examples
sqlhive

what are the differences between SQL and Hive?

What are the main differences b/w SQL and HIve?

Its for the interview purpose

Solution

  • SQL and HiveQL are programming language that helps to improve the design of the database. Some people tend to use them alternating but they are quite different.

    SQL & HiveQL

    • Both can be used on structured data
    • HiveQL support schema for data insertion while SQL support schema for data storage
    • SQL is used when we need frequent modification in records whereas HiveQL to query large data sets and analyze historical data.
    • SQL has hundreds of built-in functions while HiveQL has a limited number of built-in functions.
    • SQL support updates, delete, and insert while HiveQL does not support any.