0 votes
in Big Data | Hadoop by
What is a Managed table in Hive?

1 Answer

0 votes
by

Managed tables are the tables in which files, metadata and statistics etc are managed by internal Hive processes. Hive creates Managed tables by default. When we drop a managed table or partition, then all the metadata and data associated with the table is also deleted.

We use Managed tables, when we want Hive to manage the lifecycle of a table. Even for temporary

 

tables, we use managed tables in Hive.

When we run DESCRIBE FORMATTED tableName statement, it displays whether a table is MANAGED_TABLE or EXTERNAL_TABLE.

Related questions

0 votes
asked Apr 3, 2020 in Big Data | Hadoop by Tate
0 votes
asked Apr 3, 2020 in Big Data | Hadoop by Tate
...