in Hive by (31.6k points)

What is the difference between an external table and a managed table in Hive?

1 Answer

0 votes
by (31.6k points)

External tables in Hive refer to the data that is at an existing location outside the warehouse directory

Hive deletes the metadata information of a table and does not change the table data present in HDFS

Also known as the internal table, these types of tables  manage the data and move it into its warehouse directory by default 

If one drops a managed table, the metadata information along with the table data is deleted from the Hive warehouse directory

Related questions

+1 vote
asked Dec 3, 2020 in Hive by sharadyadav1986 (31.6k points)