Hive数据存储在哪里? [英] Where does the Hive data gets stored?

问题描述

我对配置单元在哪里存储数据感到困惑.

I am a little confused on where does the hive stores it's data.

它将数据存储在HDFS还是RDBMS中?Hive Meta存储是否使用RDBMS存储Hive表元数据??

Does it stores it's data in HDFS or in a RDBMS ?? Does Hive Meta store uses a RDBMS to store the hive tables metadata ??

预先感谢！

推荐答案

配置单元数据存储在 Hadoop兼容文件系统 :S3，HDFS或其他兼容文件系统.

Hive data are stored in one of Hadoop compatible filesystem: S3, HDFS or other compatible filesystem.

配置单元元数据存储在MySQL之类的RDBMS中，请参见 受支持的RDBMS .

Hive metadata are stored in RDBMS like MySQL, see supported RDBMS.

可以为托管表和外部表指定Hive表数据在S3或HDFS中的位置.

The location of Hive tables data in S3 or HDFS can be specified for both managed and external tables.

托管表和外部表之间的区别在于，托管表中的 DROP TABLE 语句将删除该表并删除该表的数据.而对于外部表 DROP TABLE 将仅删除该表，并且数据将保持不变，并可用于在其上创建其他表.

The difference between managed and external tables is that DROP TABLE statement, in managed table, will drop the table and delete table's data. Whereas, for external table DROP TABLE will drop only the table and data will remain as is and can be used for creating other tables over it.

在此处查看详细信息: 创建/删除/截断表

See details here: Create/Drop/Truncate Table

这篇关于Hive数据存储在哪里?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！