Drop a table in Hive

Question

Hi Guys,

I have created some tables in Hive. I want to delete one table. How can I do that?

Answer 1

Hi@akhtar,

When you drop a table from Hive Metastore, it removes the table/column data and their metadata. It can be a normal table or an external table; Hive treats both in the same manner, irrespective of their types. You can use the below command to drop the table.

$ DROP TABLE IF EXISTS employee;