Question: what is the difference between hive internal and external tables?
Answer: There are two types of tables in Hive, one is internal and second is external. The difference is, when you drop a table, if it's internal one, hive deletes both data and Metadat and if it's external hive deletes only Metadata. To create the external table, it is required to use external keyword.