#NoPayJan Offer - Access all CloudxLab Courses for free between 1st to 31st Jan

  Enroll Now >>

Hive - Tables

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.


No hints are availble for this assesment

Answer is not availble for this assesment

Loading comments...