Shulou(Shulou.com)05/31 Report--

This article is to share with you about the differences between hive and mysql. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

Differences: 1. Mysql uses SQL language, Hive uses SQL-like query language HQL. 2. Hive does not support data rewriting and addition, but Mysql supports it. 3. Hive has no index, while MySQL has index. 4. The bottom layer of Hive is MarReduce,MySQL, and the bottom layer is the execution engine.

MySQL logical architecture diagram:

Architecture diagram of Hive:

(recommended tutorial: mysql video tutorial)

Comparison between Hive and MySQL:

Hive adopts SQL-like query language HQL (hive query language). There is no resemblance except for HQL. Hive is designed for data warehouses.

Storage location: Hive on Hadoop; Mysql stores data on device or local system

Data update: Hive does not support data rewriting and adding, which is determined when loading; the database can be CRUD

Index: Hive has no index and scans all data at a time. The underlying layer is MR. Parallel computing is suitable for large amounts of data. MySQL has indexes and is suitable for querying data online.

Execution: the bottom layer of Hive is MarReduce;MySQL, and the bottom layer is the execution engine.

Scalability: Hive: large amount of data, slowly expand it; MySQL: relatively few

Thank you for reading! This is the end of the article on "what's the difference between hive and mysql". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.