Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-07-2023 09:59 PM
From the metrics above, we could see that totalConsideredFiles is 2137 and totalFilesSkipped is 2137. So, all files were skipped during this Optimize.
Could you try modifying this flag - spark.databricks.delta.optimize.preserveInsertionOrder false?
For modifying it at cluster level. Go to Advanced Settings of the Cluster and Spark Options.
spark.databricks.delta.optimize.preserveInsertionOrder false
For notebook level use below code
spark.conf.set("spark.databricks.delta.optimize.preserveInsertionOrder", false)