什么是hive，是数据库吗? [英] What is hive, Is it a database?

问题描述

我刚刚开始探索 Hive.它具有类似于 RDBMS 的所有结构，如表、连接、分区……我的理解是 Hive 仍然使用 HDFS 进行存储，它是 HDFS 的 SQL 抽象.由此我不确定天气 Hive 本身是一个像 HBase、Cassnadra 一样的数据库解决方案，或者只是一个基于 HDFS 的查询系统.我不认为它只是一种查询语言，因为它具有表、连接和分区..

I just started exploring Hive. It has all the structures similar to an RDBMS like tables, joins, partitions.. what i understand is Hive still uses HDFS for storage and it is an SQL abstraction of HDFS. From this I am not sure weather Hive itself is a database solution like HBase, Cassnadra.. or simply it is a query system on top of HDFS. I don't think it is simply a query language because it has tables, joins and partitions..

推荐答案

Hive 是一个构建在 Hadoop 之上的数据仓库包/基础设施.它提供了一种称为 Hive 查询语言 (HQL) 的 SQL 方言，用于查询存储在 Hadoop 集群中的数据.与广泛使用的所有 SQL 方言一样，HQL 并不完全符合 ANSI SQL 标准的任何特定修订版.它可能最接近 MySQL 的方言，但有显着差异.Hive 不支持行级插入、更新和删除.Hive 不支持事务.所以我们无法将其与 RDBMS 进行比较.Hive 添加了扩展以在 Hadoop 上下文中提供更好的性能，并与自定义扩展甚至外部程序集成.它非常适合批处理数据，例如:日志处理、文本挖掘、文档索引、面向客户的商业智能、预测建模、假设检验等

Hive is a data warehousing package/infrastructure built on top of Hadoop. It provides an SQL dialect called Hive Query Language (HQL) for querying data stored in a Hadoop cluster. Like all SQL dialects in widespread use, HQL doesn’t fully conform to any particular revision of the ANSI SQL standard. It is perhaps closest to MySQL’s dialect, but with significant differences. Hive offers no support for row level inserts, updates, and deletes. Hive doesn’t support transactions. So we can't compare it with RDBMS. Hive adds extensions to provide better performance in the context of Hadoop and to integrate with custom extensions and even external programs. It is well suited for batch processing data like: Log processing, Text mining, Document indexing, Customer-facing business intelligence, Predictive modeling, hypothesis testing etc.

Hive 不是为在线事务处理而设计的，也不提供实时查询.

Hive is not designed for online transaction processing and does not offer real-time queries.

这篇关于什么是hive，是数据库吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！