What is the use of PURGE in DROP statement of Hive?

hive purge
Gaurav Gangwar picture Gaurav Gangwar · Aug 9, 2018 · Viewed 9.7k times · Source

Hi Please describe the difference between both in hive with example.

Answer

juamd picture juamd · Aug 11, 2018

DROP TABLE [IF EXISTS] table_name [PURGE];

If you don't use purge the table goes to a Trash directory, from there the table can be recovered after drop it. But if you do use purge table won't go to Trash directory, so it can't be recovered.

Regards !!

Related questions

How to delete and update a record in Hive

I have installed Hadoop, Hive, Hive JDBC. which are running fine for me. But I still have a problem. How to delete or update a single record using Hive because delete or update command of MySQL is not working in …

Read More
How to know Hive and Hadoop versions from command prompt?

How can I find which Hive version I am using from the command prompt. Below is the details- I am using Putty to connect to hive table and access records in the tables. So what I did is- I opened …

Read More
Hive insert query like SQL

I am new to hive, and want to know if there is anyway to insert data into hive table like we do in SQL. I want to insert my data into hive like INSERT INTO tablename VALUES (value1,value2..) I …

Read More