Jan 12, 2020 in Big Data | Hadoop
Q: What is a Managed table in Hive?

1 Answer

0 votes
Jan 12, 2020

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.

Click here to read more about Loan/Mortgage
Click here to read more about Insurance

Related questions

0 votes
Apr 3, 2020 in Big Data | Hadoop