Question: what is the difference between internal table and external table?
Answer: External table is created for external use as when the data is used outside Hive. Whenever we want to delete the table's metadata and we want to keep the table's data as it is, we use an External table. External table only deletes the schema of the table. A managed table is also called an Internal table.