CODE EXAMPLE FOR SQL

athena drop partition

ALTER TABLE orders 
DROP PARTITION (dt = '2014-05-14', country = 'IN');