4 / 18

Hive - Tables

Not able to play video? Try with youtube

There are two types of tables in Hive. Managed and external.

Let's understand managed tables in Hive. Hive managed tables are also called Internal tables. The lifecycle of a Managed table is managed by Hive. In managed table data is stored in the default warehouse directory which is /apps/hive/warehouse in HDFS. If we drop a managed table, the underlying data as well as metadata both are deleted.

The life cycle of an External table is not managed by Hive. Hive assumes that it does not own underlying data. If we drop an external table, only metadata is deleted and the underlying data remains at the location specified in the table definition.

Loading comments...