in Big Data | Hadoop by
Q:
What is the difference between external table and managed table?

1 Answer

0 votes
by

Here is the key difference between an external table and managed table:

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

On the contrary, in case of an external table, Hive just deletes the metadata information regarding the table and leaves the table data present in HDFS untouched. 

Note: I would suggest you to go through the blog on Hive Tutorial to learn more about Managed Table and External Table in Hive.

Click here to read more about Loan/Mortgage
Click here to read more about Insurance

Related questions

0 votes
asked Jan 12, 2020 in Big Data | Hadoop by sharadyadav1986
0 votes
0 votes
asked Apr 1, 2020 in Big Data | Hadoop by AdilsonLima
0 votes
asked Mar 22, 2020 in Big Data | Hadoop by SakshiSharma
0 votes
asked Jan 12, 2020 in Big Data | Hadoop by sharadyadav1986
0 votes
asked Jan 11, 2020 in Big Data | Hadoop by rajeshsharma
...