Difference between Hive internal tables and external tables?

Question

Can someone tell me what is metadata? What is the difference between Internal tables and external tables in the hive? Select the correct answer from above options questions and answers, questions pdf, question bank, questions and answers pdf, mcq on pdf, questions and solutions, mcq Test , Interview questions, Questions for Interview, MCQ (Multiple Choice Questions),Core Questions, Core Hadoop MCQ,core interview questions for experienced

Answer 1

To keep a track of state on its master node Hive has a relational database. If you have a partitioned table, the partitions are stored in the database(this allows hive to use lists of partitions without going to the file-system and finding them). These sort of things are the 'metadata'. If you drop a table, Hive returns the state it absolutely was in before you dropped the table. If you run the query 'select * from jay' after you drop jay, hive will tell you the table doesn’t exist. This happens as you have told hive to forget that table. So, internal tables are used when we want Hive to completely manage table and the data. While the external tables are used when the data is also used outside of Hive.