How does V-ORDER exactly work?

[amaaiia]

Hi,

Which is de equivalent of running V-ORDER with visual interface in Spark SQL?

I mean, the equivalent of OPTIMIZE would be:

query = f"OPTIMIZE {table_name} ZORDER BY ({col1}, {col2})"
spark.sql(query)

VACUUM:

query = f"VACUUM {table_name} RETAIN {retention_hours} HOURS"
spark.sql(query)

Which would be de equivalent of running V-ORDER?

[lbendlin · Accepted solution]

Delta Lake table optimization and V-Order - Microsoft Fabric | Microsoft Learn