admin管理员组

文章数量:1026989

I find the docs about the depth-related metrics in Snowflake to be somewhat lacking. Regarding average_overlaps, we can read the following:

Average number of overlapping micro-partitions for each micro-partition in the table.

What does this mean precisely? Is it something like:

sum_overlaps = 0
let partitions = all micro partitions 
for p in partitions:
    sum_overlaps += number_of_overlapping_partitions(p)
return sum_overlaps/len(partitions)

where number_overlapping_partitions(p) simply returns the number of partitions that overlap with p in some range of the cluster key values?

I find the docs about the depth-related metrics in Snowflake to be somewhat lacking. Regarding average_overlaps, we can read the following:

Average number of overlapping micro-partitions for each micro-partition in the table.

What does this mean precisely? Is it something like:

sum_overlaps = 0
let partitions = all micro partitions 
for p in partitions:
    sum_overlaps += number_of_overlapping_partitions(p)
return sum_overlaps/len(partitions)

where number_overlapping_partitions(p) simply returns the number of partitions that overlap with p in some range of the cluster key values?

本文标签： snowflake cloud data platformWhat does averageoverlaps actually meanStack Overflow

版权声明：本文标题：snowflake cloud data platform - What does average_overlaps actually mean? - Stack Overflow 内容由热心网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://it.en369.cn/questions/1745660434a2161856.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。