Home  >  Article  >  Database  >  What is the difference between hive and mysql

What is the difference between hive and mysql

青灯夜游
青灯夜游Original
2021-03-01 17:05:1235183browse

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

What is the difference between hive and mysql

The operating environment of this tutorial: windows7 system, mysql8 version, Dell G3 computer.

  • MySQL logical architecture diagram:

What is the difference between hive and mysql

  • Hive architecture diagram:

What is the difference between hive and mysql

(Recommended tutorial: mysql video tutorial)

Hive and MySQL Comparison:

  • Hive uses a SQL-like query language HQL (hive query language). There is nothing similar except HQL. Hive is designed for data warehouses.

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

  • Data update: Hive does not support data The rewriting and addition are already determined when loading; the database can be CRUD;

  • Index: Hive has no index, all data is scanned each time, the bottom layer is MR, parallel computing , suitable for large amounts of data; MySQL has indexes, suitable for online query data;

  • Execution: The bottom layer of Hive is MarReduce; the bottom layer of MySQL is an execution engine;

  • Scalability: Hive: Large data volume, expand slowly; MySQL: relatively small

For more programming-related knowledge, please visit: Introduction to programming! !

The above is the detailed content of What is the difference between hive and mysql. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn