Why is HBase hot? It applies to those business scenarios.

The main difference between hbase and hive is that they have different ways to store and manage their internal data. The main feature of hbase is to imitate the column potential storage of bigtable. For the storage of large-scale data, query has great advantages over traditional databases, while hive mainly deals with the problem of data warehouse, mapping the file directory structure existing on hdfs to tables. The main concern is the statistics of data.

Applicable scenarios:

Hbase: It is suitable for large-scale data storage, and its functions can be comparable to those of traditional databases, mainly focusing on data access.

Hive: It is suitable for the management, statistics and processing of big data, and its function is similar to that of traditional data warehouse, focusing on data processing.

Summary: When dealing with big data, if you are concerned with data storage and querying hbase, but you are concerned with querying the processing results of big data, it is undoubtedly more suitable. For example, when querying, using functions such as count and sum to operate hive can meet the demand. Generally, some items are input into hive for data processing, and then the results are imported into mysql and other databases or hbase for query. As for the choice of mysql and hbase, I prefer the amount of data you process.