What is the difference between Hive internal table and external table

This article mainly explains "what is the difference between Hive internal table and external table". The explanation in this article is simple and clear, easy to learn and understand. Please follow the ideas of Xiaobian and study and learn "what is the difference between Hive internal table and external table" together.

Internal table data is managed by Hive itself, external table data is managed by HDFS;

The storage location of internal table data is hive.metastore.warehouse.dir (default: /user/hive/warehouse), and the storage location of external table data is determined by yourself;

Deleting internal tables deletes metadata and stored data directly; deleting external tables deletes metadata only, and files on HDFS are not deleted;

Changes to internal tables synchronize the changes directly to metadata, while changes to table structure and partitioning of external tables require repair (MSCK REPAIR TABLE table_name;)

Thank you for your reading. The above is the content of "What is the difference between Hive internal table and external table?" After studying this article, I believe you have a deeper understanding of the difference between Hive internal table and external table. The specific use situation still needs to be verified by practice. Here is, Xiaobian will push more articles related to knowledge points for everyone, welcome to pay attention!