1. Structured Query Language (SQL) :
SQL is a domain-specific language used in programming and designed for managing data held in a relational database management system also known as RDBMS. It is also useful in handling structured data, i.e., data incorporating relations among entities and variables. SQL is a standard language for storing, manipulating and retrieving data in databases.
2. Hive Query Language (HiveQL) :
HiveQL is a query language for Hive to analyze and process structured data in a Meta-store. It is very much similar to SQL and highly scalable. It reuses familiar concepts from the relational database world, such as tables, rows, columns and schema, to ease learning. Hive supports four file formats those are TEXT FILE, SEQUENCE FILE, ORC and RC FILE (Record Columnar File).
Difference between SQL and HiveQL :
| On the basis of | SQL | HiveQL |
|---|---|---|
| Update-commands in table structure | UPDATE, DELETE INSERT, |
UPDATE, DELETE INSERT, |
| Manages | Relational data | Data Structures |
| Transaction | Supported | Limited Support Supported |
| Indexes | Supported | Supported |
| Data Types | It contain a total of five data types i.e., Integral, floating-point, fixed-point, text and binary strings, temporal | It contains a total of 9 data types i.e., Boolean, integral, floating-point, fixed-point, text and binary strings, temporal, array, map, struct. |
| Functions | Hundreds of built-in functions | Hundreds of built-in functions |
| Mapreduce | Not Supported | Supported |
| Multitable inserts in table | Not supported | Supported |
| Create tabl…as Select | Not supported | Supported |
| Select command | Supported | Supported with SORT BY clause for partial ordering and LIMIT to restrict number of rows returned |
| Joins | Supported | Inner joins, outer joins, semi join, map joins, cross joins |
| Subqueries | Supported | Only Used in FROM, WHERE, or HAVING clauses |
| Views | Can be Updated | Read-only i.e. cannot be updated |
Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.
Recommended Posts:
- Difference between Structured Query Language (SQL) and Transact-SQL (T-SQL)
- SQL | Difference between functions and stored procedures in PL/SQL
- Difference between T-SQL and PL-SQL
- Difference between SQL and T-SQL
- SQL | Procedures in PL/SQL
- Difference between Static and Dynamic SQL
- Difference between Simple and Complex View in SQL
- Difference between SQL and NoSQL
- Difference between SQL and PLSQL
- Difference between DELETE and DROP in SQL
- Difference between MySQL and MS SQL Server
- Difference between JOIN and UNION in SQL
- Difference between COMMIT and ROLLBACK in SQL
- Difference between DROP and TRUNCATE in SQL
- Difference between Where and Having Clause in SQL
- Difference between order by and group by clause in SQL
- Difference Between Hadoop and SQL Performance
- Difference between From and Where Clause in SQL
- Difference Between Hadoop and SQL
- Difference between Inner Join and Outer Join in SQL
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.
