Apache Hive: DROP TABLE [IF EXISTS] table_name [PURGE]; "If PURGE is specified, the table data does not go to the .Trash/Current directory and so cannot be retrieved in the event of a mistaken DROP. The purge option can also be specified with the table property auto.purge (see TBLPROPERTIES above)."