Forum Discussion
amaaiia
1 year agoSkilled Sharer
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?