https://community.databricks.com/t5/data-engineering/can-i-give-partition-filter-conditions-for-the-vacuum-command/m-p/19751#M13284 <P>For the optimize command, I can give predicates and it's easy to optimize the partitions where the data is added. Similarly, can I specify the "WHERE" clause on the partition for a VACUUM command</P> Fri, 25 Jun 2021 14:15:58 GMT brickster_2018 2021-06-25T14:15:58Z https://community.databricks.com/t5/data-engineering/can-i-give-partition-filter-conditions-for-the-vacuum-command/m-p/19751#M13284 <P>For the optimize command, I can give predicates and it's easy to optimize the partitions where the data is added. Similarly, can I specify the "WHERE" clause on the partition for a VACUUM command</P> Fri, 25 Jun 2021 14:15:58 GMT https://community.databricks.com/t5/data-engineering/can-i-give-partition-filter-conditions-for-the-vacuum-command/m-p/19751#M13284 brickster_2018 2021-06-25T14:15:58Z https://community.databricks.com/t5/data-engineering/can-i-give-partition-filter-conditions-for-the-vacuum-command/m-p/19752#M13285 <P>It's by design, VACUUM command does not support filters on the partition columns. This is because removing the old files partially can leave can impact the time travel feature.&nbsp;</P> Fri, 25 Jun 2021 14:16:17 GMT https://community.databricks.com/t5/data-engineering/can-i-give-partition-filter-conditions-for-the-vacuum-command/m-p/19752#M13285 brickster_2018 2021-06-25T14:16:17Z