Login using Social Account
     Continue with GoogleLogin using your credentials
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.
Taking you to the next exercise in seconds...
Want to create exercises like this yourself? Click here.
Loading comments...