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
Clarify about the smb join in hive?
Differentiate between describe and describe extended?
Explain Clustering in Hive?
What are the different collection type in Hive?
Explain the Differences between Hive and Spark SQL?
Is hive a nosql database?
What is the difference between piglatin and hiveql?
What are the three different modes in which hive can be run?
Which java class handles the output record encoding into files which result from Hive queries?
Explain Data Type Conversion in Hive?
What is the utilization of hcatalog?
What are collection data types in Hive?
If you run a select * query in hive, why does it not run mapreduce?
How to skip header rows from a table in Hive?
What will be the result when you do cast(‘abc’ as int)?