Hive tables Creation

hive

#1

When to use the managed table and the external table? Is there any particulars to create those tables?


#2

Could you explain the question a little better?


#3

When should we use the external and internal tables ?


#4

@nikhil23 Its all depends upon the use case. I meant that if you want to retain the underlying the data even though you drop the table (i.e including the metadata) then “External Table” is a choice else “Internal Table” because when you drop an internal table then it will delete the underlying data including metadata.


#5

Thanks for the help sir