When use managed and external table in Hive?

What is the difference between external and managed tables?

¶ The main difference is that when you drop an external table, the underlying data files stay intact. This is because the user is expected to manage the data files and directories. With a managed table, the underlying directories and data get wiped out when the table is dropped.

When would you choose to create an external Hive table?

Use EXTERNAL tables when:1The data is also used outside of Hive. ... 2Data needs to remain in the underlying location even after a DROP TABLE. ... 3You want to use a custom location such as ASV.4Hive should not own data and control settings, dirs, etc., you have another program or process that will do those things.

What is the use of external table in Hive?

An external table is a table for which Hive does not manage storage. If you delete an external table, only the definition in Hive is deleted. The data remains. An internal table is a table that Hive manages.

In which of the following cases should you use an external table in Hive?

We can use the external table in cases:When we are not creating the table based on the existing table.When required to use data outside of Hive. ... When we don't want to delete the table data completely even after DROP.When the data should not be own by Hive.