Error on UC Liquid Clustering

[RobsonNLPT]

I know we have 4 keys max on cluster by () for both z-order and partition keys. I got some issues when adding 4 keys and 1 specific key triggers that error (I was not expecting as this is about Create Table) . Stats makes sense if you need to optimize an existing clustering strategy due to changes on data profile DeltaAnalysisException: Liquid clustering requires clustering columns to have stats

[RobsonNLPT]

I'm aware about the feature and definitions. I've created an empty table enabled to LC using 4 keys.

I've got the error "DeltaAnalysisException: Liquid clustering requires clustering columns to have stats"

How its possible if I just created an empty table?

[-werners- · Accepted solution]

are you sure the 4 columns you defined for LC are statistics-enabled?
By default, only the first 32 are used.  This can be overridden (up or down).

[RobsonNLPT]

My table has only 19 columns

[RobsonNLPT]

That's correct. One of the cluster keys I was trying to clustering is not on top 32 positions

Thank you 

[JurneeSalinas]

Any update?

[swoop-dave]

Is Liquid cluster also helpful for high cardinality columns for a table Join?