Hive Internal and External Table in Big Data Hadoop
->Internal Table or Managed Table, is the one that is managed by Hive.
->When we point data in HDFS to such table, the data is moved to Hive default location /usr/hive/warehouse/. And, then if such internal table is dropped, the data is deleted along with.
->External table on the other hand is user managed, and data is not moved to hive default directory after loading i.e, any custom location can be specified. Consecutively, when drop such table, no data is deleted, only table schema is dropped from meta database.
Post Your Comment