Categories

Jan 12 in Big Data | Hadoop

Q: What is a Managed table in Hive?

1 Answer

Jan 12

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

Madanswer
Jan 10 in Big Data | Hadoop
Apr 3 in Big Data | Hadoop
Apr 3 in Big Data | Hadoop
...