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


Please Help Members By Posting Answers For Below Questions

what are views in Hive?

464


What is bucketing ?

399


What is a generic UDF in the hive?

403


What is different table structure available in the hive?

426


What in hive made out of?

419






What database are supported by Hive?

407


Specify the different methods of hive?

397


CONCAT function in Hive with Example?

504


What is the significance of the line set hive.mapred.mode = strict;?

486


What does meta-store means in hive?

401


What is the precedence order of hive configuration?

637


What are the different collection type in Hive?

437


Mention Hive default read and write classes?

446


What does the “USE” command in the hive do?

403


if you run Hive as a server?

636