Hive tables Creation



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


Could you explain the question a little better?


When should we use the external and internal tables ?


@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.


Thanks for the help sir