topic Re: Error on UC Liquid Clustering in Get Started Discussions

Error on UC Liquid Clustering

RobsonNLPT — Wed, 07 Feb 2024 10:47:41 GMT

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

Re: Error on UC Liquid Clustering

RobsonNLPT — Wed, 07 Feb 2024 12:02:28 GMT

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?

Re: Error on UC Liquid Clustering

-werners- — Wed, 07 Feb 2024 12:57:25 GMT

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).

Re: Error on UC Liquid Clustering

RobsonNLPT — Wed, 07 Feb 2024 15:45:43 GMT

My table has only 19 columns

Re: Error on UC Liquid Clustering

JurneeSalinas — Tue, 13 Feb 2024 13:10:43 GMT

Any update?

Re: Error on UC Liquid Clustering

RobsonNLPT — Thu, 15 Feb 2024 11:17:35 GMT

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

Thank you

Re: Error on UC Liquid Clustering

swoop-dave — Wed, 11 Sep 2024 14:53:13 GMT

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