What is difference between internal and external tables in hive?
Answer Posted / rajasekhar
if you drop a table in internal mode then table schema and files get deleted.
If you drop a table in external mode then table shema will be gone but files will be present.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain Clustering in Hive?
Explain when to use explode in Hive?
How hive can improve performance with orc format tables?
What are the views in Hive?
Wherever (Different Directory) I run the hive query, it creates new metastore_db, please explain the reason for it?
Explain REPEAT function in Hive with example?
How to change a column data type in Hive?
Differentiate between PigLatin and Hive?
Mention what is ObjectInspector functionality in Hive?
How do you list all databases whose name starts with p?
Is it possible to change the default location of Managed Tables in Hive, if so how?
What do you understand by hive?
What happened after creating a table in hive ?
What are the components of a Hive query processor?
What is the maximum size of string data type supported by Hive?