How does V-ORDER exactly work?

amaaiia — Tue, 14 Jan 2025 15:48:19 GMT

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?

Re: How does V-ORDER exactly work?

lbendlin — Tue, 14 Jan 2025 16:33:05 GMT