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

Its for the interview purpose

CodePudding user response：

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

• SQL is for structured data and is for RDBMS while HiveQL is for structured data only.
• 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.

CodePudding user response：

HIVE
This is a tool by Apache built to query large distributed storages (mostly hadoop distributed file system) by using a SQL like language or statements. Its a tool to facilitate users who are familiar with SQL to work on HDFS. So, like any DB query tool it has few components like - query parser, query executor, coordinator, resource manager etc. to work properly.
You can get more info here

SQL
In comparison to hive, this is an umbrella term for querying information from a structured data. So, this is just a language like C, C , Python with proper syntax/format/standards etc. and any developer can use this to access/modify any structured data. People can write long paragraph on this but you can read all about from Wiki.