Question

what is the difference between external table and managed table in hive

Answer 1

There are two types of tables in Hive, one is internal and second is external. The difference is, when you drop atable, if it's internal one, hive deletes both data and Metadat and it itsexternal hive deletes only Metadata. To create the external table, it isrequired to use external keyword.

Answer 2

Hive may have internal or external tables, this is a choice that affects how data is loaded, controlled, and managed. Use EXTERNAL tables when: The data is also used outside of Hive. For example, the data files are read and processed by an existing program that doesn't lock the files.