topic Re: drop specific partition from a Delta Table in Data Engineering

drop specific partition from a Delta Table

HanaSega_97455 — Thu, 01 Jun 2023 09:30:40 GMT

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?

Re: drop specific partition from a Delta Table

Lakshay — Thu, 01 Jun 2023 13:14:07 GMT

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

Re: drop specific partition from a Delta Table

Anonymous — Tue, 06 Jun 2023 08:40:42 GMT

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!