Forum Discussion

amaaiia's avatar
amaaiia
Skilled Sharer
1 year ago
Solved

How does V-ORDER exactly work?

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?