cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Data Engineering
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

How many columns does Delta Engine collect stats on for a Delta Table

Anand_Ladda
Honored Contributor II
 
1 ACCEPTED SOLUTION

Accepted Solutions

Anand_Ladda
Honored Contributor II

by default a delta table has stats collected on the first 32 columns. This setting can be configured using the following.

set spark.databricks.delta.properties.defaults.dataSkippingNumIndexedCols = 3

However there's a time trade-off to having a large number of columns set for stats collection. You typically want to collect stats on column that are used in filter, where clauses joins and on which you tend to performance aggregations.

View solution in original post

1 REPLY 1

Anand_Ladda
Honored Contributor II

by default a delta table has stats collected on the first 32 columns. This setting can be configured using the following.

set spark.databricks.delta.properties.defaults.dataSkippingNumIndexedCols = 3

However there's a time trade-off to having a large number of columns set for stats collection. You typically want to collect stats on column that are used in filter, where clauses joins and on which you tend to performance aggregations.

Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.