What are the differences between hive and mysql

Difference: 1. Hive is hql language, mysql is sql language; 2. hive stores data in hdfs, while mysql stores it in its own system; 3. hive data format can be customized, but mysql does not Yes; 4. Hive does not support data update, but MySQL does; 5. Hive does not have indexes, but MySQL does; 6. The amount of data stored in Hive is extremely large, but MySQL has a small storage capacity; 7. The bottom layer of Hive uses mapreduce, and MySQL is executed by excutor. device.

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

What is mysql

MySQL is a relational database management system developed by the Swedish MySQL AB company and is a product of Oracle. MySQL is one of the most popular relational database management systems. In terms of WEB applications, MySQL is one of the best RDBMS (Relational Database Management System) application software.

MySQL is a relational database management system. A relational database stores data in different tables instead of placing all data in one large warehouse, which increases speed and flexibility.

The SQL language used by MySQL is the most commonly used standardized language for accessing databases. MySQL software adopts a dual licensing policy and is divided into community version and commercial version. Due to its small size, fast speed, low total cost of ownership, and especially the characteristics of open source, MySQL is generally chosen as the website for the development of small, medium and large websites. database.

What is hive

hive is a data warehouse tool based on Hadoop, which is used to extract, transform and load data. A mechanism that can store, query, and analyze large-scale data stored in Hadoop. The hive data warehouse tool can map structured data files into a database table, and provides SQL query functions, which can convert SQL statements into MapReduce tasks for execution.

The advantage of Hive is that it has low learning cost and can implement fast MapReduce statistics through similar SQL statements, making MapReduce simpler without having to develop a specialized MapReduce application. hive is very suitable for statistical analysis of data warehouses.

The difference between Hive and mysql

1. Different query languages:

hive uses a SQL-like query language HQL (hive query language), mysql uses sql language.

2. Data storage locations are different:

hive stores data in hdfs, while mysql data is stored in its own system

3. Data format:

hive data format can be customized by users, mysql has its own system-defined format

4. Data update:

hive does not support data update, it can only be read, not written, sql Supports reading and writing of data

5. Index:

hive does not have an index, so when querying data, mapreduce is used to query all the data violently, which also causes hive to query data very quickly. The reason for slowness, and mysql has indexes;

6. Data scale:

hive stores a very large amount of data, while mysql only stores a small amount of business data

7 , The underlying execution principle:

The bottom layer of hive uses mapreduce, and mysql is the excutor executor;

[Related recommendations: mysql video tutorial]

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