什么是配置单元，它是一个数据库吗？ [英] What is hive, Is it a database?

问题描述

我刚开始探索Hive。它具有类似于RDBMS的所有结构，如表，连接，分区......我所理解的是Hive仍然使用HDFS进行存储，并且它是HDFS的SQL抽象。从这个我不知道天气Hive本身是一个数据库解决方案，如HBase，Cassnadra ..或简单地说它是一个查询系统在HDFS之上。我不认为它只是一种查询语言，因为它具有表，连接和分区。

Hive是一个数据仓库包/基础架构构建于Hadoop之上。它提供了SQL方言，称为Hive查询语言（HQL），用于查询存储在Hadoop集群中的数据.HQL是Hive查询语言。像所有广泛使用的SQL方言一样，它不完全符合ANSI SQL标准的任何特定版本。它也许最接近MySQL的方言，但有很大的不同。 Hive不支持rowlevel插入，更新和删除。 Hive不支持事务。因此我们无法将其与RDBMS进行比较。 Hive添加了扩展，以便在Hadoop环境中提供更好的性能，并与定制扩展甚至外部程序集成。它非常适合批量处理数据，如：日志处理，文本挖掘，文档索引，面向客户的商业智能，
预测建模，假设测试等。

Hive不适用于在线交易处理，并且不提供实时查询。

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 a having tables, joins and partitions..

解决方案

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.HQL is the Hive query language. Like all SQL dialects in widespread use, it 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 rowlevel 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 is not designed for online transaction processing and does not offer real-time queries.

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