title: Difference between Hive internal tables and external tables?
body: <p>Can anyone tell me the difference between Hive's external table and internal tables.
  I know the difference comes when dropping the table. I don't understand what you mean by the data and metadata is deleted in internal and only metadata is deleted in external tables.
  Can anyone explain me in terms of nodes please.</p>