What happens when a managed table is dropped?

What happens when a managed table is dropped in Hive?

When you drop a table from Hive Metastore, it removes the table/column data and their metadata. It can be a normal table (stored in Metastore) or an external table (stored in local file system); Hive treats both in the same manner, irrespective of their types.

What happens when a managed table is dropped in Hive Mcq?

As it is hive managed table both the data and schema definition are dropped.

What happens when you drop an external table Hive?

DROP TABLE names_text; The table is removed from Hive Metastore and the data stored externally. For example, names_text is removed from the Hive Metastore and the CSV file that stored the data is also deleted from HDFS.

When you drop an internal table in Hive it simply deletes the metadata information as well as the table data?

To answer you Question : If the external table is dropped, then the table metadata is deleted but not the data. For Internal tables, Hive stores data into its warehouse directory. If the table is dropped then both the table metadata and the data will be deleted.