in Big Data | Hadoop by
Q:
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 Jan 10, 2020 in Big Data | Hadoop by sharadyadav1986
  • #external-vs-manage-table
0 votes
asked Mar 14 in Web Hosting by SakshiSharma
0 votes
0 votes
asked Apr 3, 2020 in Big Data | Hadoop by Tate
...