drop specific partition from a Delta Table

[HanaSega_97455]

i have a delta table partitioned by a Date column , I'm trying to use the alter table drop partition command but get ALTER TABLE DROP PARTITION` is not supported for Delta tables error

is there a way to do it?

[Lakshay · Accepted solution]

You can use the Delete command to delete the data for one partition.

[Anonymous]

Hi @Hanan Segal​ 

Thank you for posting your question in our community! We are happy to assist you.

To help us provide you with the most accurate information, could you please take a moment to review the responses and select the one that best answers your question?

This will also help other community members who may have similar questions in the future. Thank you for your participation and let us know if you need any further assistance!