0

I have a table with multiple partitions. I have deleted few partition records in hdfs. How can I drop all the empty partitions in the corresponding hive table at once.

Codeit
  • 21
  • 3
  • "I have deleted few partition records in hdfs" - does it mean you deleted partition folders? – leftjoin Feb 01 '20 at 19:10
  • Yes, i have deleted few partitions(partition folders) in hdfs. Let's say i have total of 10 partitions in a table, i have now deleted 4 of those partitions in hdfs, is there a query to drop all the empty partitions?? Without mentioning the partition value in the hive query. – Codeit Feb 02 '20 at 11:30

0 Answers0