z-order

[Amy]

If I run "create or replace table..." to replace an existing delta table, should I apply OPTIMIZE Z ORDER.. again ? or the Z-ordering would maintain same as before the replace ?

[Venki Korukanti]

Hi Amy, 

if the data in the table changes you need to run the Z-order again to cluster the data. You can apply partition predicate to Zorder command to restrict the Z-order rebuild only on patroons that have data changed. Please see 

https://docs.delta.io/2.0.0rc1/optimizations-oss.html#z-ordering-multi-dimensional-clustering for more details.

Thanks

Venki

On Tue, Jun 28, 2022 at 11:36 AM Amy <ati...@gmail.com> wrote:

If I run "create or replace table..." to replace an existing delta table, should I apply OPTIMIZE Z ORDER.. again ? or the Z-ordering would maintain same as before the replace ?

--
You received this message because you are subscribed to the Google Groups "Delta Lake Users and Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to delta-users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/delta-users/aabefb1b-7e33-4851-b966-2b0afe9c1f2bn%40googlegroups.com.