O'Reilly logo
  • Nikhil Daga thinks this is interesting:

The tables we have created so far are called managed tables or sometimes called internal tables, because Hive controls the lifecycle of their data (more or less). As we’ve seen, Hive stores the data for these tables in a subdirectory under the directory defined by hive.metastore.warehouse.dir (e.g., /user/hive/warehouse), by default.

When we drop a managed table (see Dropping Tables), Hive deletes the data in the table.

From

Cover of Programming Hive

Note

Managed Tables In Hive