Shulou(Shulou.com)06/01 Report--

What is the difference between hive and hbase? for this question, this article introduces the corresponding analysis and solution in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible way.

What they have in common:

Both 1.hbase and hive are built on top of hadoop. All use hadoop as the underlying storage.

Difference:

2.Hive is a batch processing system based on Hadoop to reduce the writing work of MapReduce jobs, and HBase is a project to support a project to make up for Hadoop's shortcomings in real-time operation.

3. Imagine you are operating a RMDB database. If it is a full table scan, use Hive+Hadoop, and if it is an index access, use HBase+Hadoop.

4.Hive query is that MapReduce jobs can run from 5 minutes to more than a few hours. HBase is very efficient and certainly much more efficient than Hive.

5.Hive itself does not store and calculate data, and it relies entirely on table-pure logic in HDFS and MapReduce,Hive.

6.hive borrows MapReduce from hadoop to execute some commands in hive.

7.hbase is a physical table, not a logical table. It provides a super-large memory hash table, through which search engines store indexes to facilitate query operations.

8.hbase is a column store.

9.hdfs is the underlying storage, hdfs is the system for storing files, and Hbase is responsible for organizing files.

10.hive needs to use hdfs storage files and the MapReduce computing framework.

This is the answer to the question about what is the difference between hive and hbase. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel to learn more about it.

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.