SQL vs Hive

In this section, we will explain the significant differences between SQL and HIVE in tabular format:

Feature	SQL	HIVE
Updates	UPDATE, DELETE INSERT	UPDATE, DELETE INSERT
Transaction	Supported	Limited Supported
Indexes	Supported	Supported
Data Types	Integral, fixed-point, floating-point, text and binary strings, temporal	Boolean, floating-point, integral, fixed-point, text and binary strings, temporal, array, map
Functions	Hundreds of built-in functions	Hundreds of built-in functions
Multi-table inserts	Not supported	Supported
Select	Supported	Supported with the only SORT BY clause for partial ordering and LIMIT to restrict the number of rows returned
Joins	Supported	Inner joins, outer joins, semi-join, map joins, cross joins
Subqueries	Used in any clause	Used in FROM, WHERE, or HAVING clauses
Views	Updatable	Read-only