in Big Data | Hadoop by
Managed Table vs External Table

The difference is during Load and Drop of a table.

Load

  • When you load data to the managed table, data is moved to the HIVE warehouse.

  • When you load data to the external table, data is not moved as during the creation of the table, location is already mentioned. The data in this table will be saved in the external location.

Drop

  • When you drop the managed table, data in the table, as well as the metadata, is being deleted. Also, it cannot be accessed from anywhere.

  • When you drop an external table, data is not being affected only the metadata gets deleted.

Related questions

0 votes
asked Mar 29, 2020 in Big Data | Hadoop by AdilsonLima
0 votes
asked Apr 3, 2020 in Big Data | Hadoop by Tate
0 votes
asked Mar 10, 2020 in Big Data | Hadoop by Hodge
0 votes
asked Jan 10, 2020 in Big Data | Hadoop by sharadyadav1986
...