Hive Partition can be dropped using
ALTER TABLE Tablename DROP IF EXISTS
PARTITION(PartitionedID=PartitionVALUE);
Lets see an example.
Say I have an emp Hive Table where there are 3 partitions for Department(A,B,C).
Inorder to delete a particular Department use the below query.
ALTER TABLE emp DROP IF EXISTS
PARTITION(Department='A');
Hi ,i just wanted the query for drop and delete and fortunately i got from your post thanks for posting useful blog ,do keep posting!! Hadoop Training in Velachery | Hadoop Training .
ReplyDeleteHadoop Training in Chennai | Hadoop .
It was really a nice article and i was really impressed by reading this Big data hadoop online training India
ReplyDelete