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
If you omit the overwrite clause while creating a hive table,what happens to file which are new and files which already exist?
what is (HS2) HiveServer2?
If you run a select * query in hive, why does it not run mapreduce?
When you are dealing with static data instead of dynamic data?
Hive new version supported Hadoop Versions ?
What is the man difference between hbase and hive?
Explain the functionality of object-inspector.
What is Hive Present Version ?
What is the use of explode in Hive?
Can you give us some examples, how Hadoop is used in real time environment?
In which scenario Hive is good fit?
Is it possible to change the default location of Managed Tables in Hive, if so how?
Is hive a nosql database?
Which java class handles the output record encoding into files which result from Hive queries?
What are the three different modes in which hive can be run?