delta-io / delta

An open-source storage framework that enables building a Lakehouse architecture with compute engines including Spark, PrestoDB, Flink, Trino, and Hive and APIs
https://delta.io
Apache License 2.0
7.62k stars 1.71k forks source link

[Feature Request] OPTIMIZE FULL/Force reclustering full table #3844

Open Dantesean opened 2 weeks ago

Dantesean commented 2 weeks ago

Feature request

Which Delta project/connector is this regarding?

Overview

Currently, it's not possible to force run a reclustering of all files in Delta, as running OPTIMIZE {table} FULL is not supported (see Databricks Delta docs.

Motivation

I've personally not been able to see the benefits of Delta clustering and when looking at the statistics of a Delta table, it seems like files that should be clustered together are spread out throughout multiple files. Running a partial optimization does not redistribute existing clusters across files.

Further details

Willingness to contribute

The Delta Lake Community encourages new feature contributions. Would you or another member of your organization be willing to contribute an implementation of this feature?