What is a managed table in Hive?

Is managed table and internal table are same in Hive?

Internal tables are also known as Managed tables that are owned and managed by Hive. By default, Hive creates a table as an Internal table and owned the table structure and the files. In other words, Hive completely manages the lifecycle of the table (metadata & data) similar to tables in RDBMS.

What is difference between managed and external table?

The main difference between a managed and external table is that when you drop an external table, the underlying data files stay intact. This is because the user is expected to manage the data files and directories. With a managed table, the underlying directories and data get wiped out when the table is dropped.

When use managed table and external table in Hive?

when we create a table in HIVE, HIVE by default manages the data and saves it in its own warehouse, where as we can also create an external table, which is at an existing location outside the HIVE warehouse directory. The main difference between these two types of tables is seen during LOAD and DROP statements.

How do I know if my Hive table is managed?

For external tables Hive assumes that it does not manage the data. Managed or external tables can be identified using the DESCRIBE FORMATTED table_name command, which will display either MANAGED_TABLE or EXTERNAL_TABLE depending on table type.