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.
The operating environment of this tutorial: windows7 system, mysql8 version, Dell G3 computer.
MySQL logical architecture diagram:
Hive architecture diagram:
(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!