Question: what is the difference between internal table and external table in hive?
Answer: Internal tables are useful if you want Hive to manage the complete lifecycle of your data including the deletion, whereas external tables are useful when the files are being used outside of Hive. Also Keep in mind that Hive is a big data warehouse. ... When you drop a 'Managed' table hive will also trash its data.