Hello,

I have a table with approximately 300 million records. It weighs 3.4 GB and consists of 305 files.

I wanted to create liquid clustering for it and chose a date column as the key for clustering.

When I created a new table with the above details based on the original table, the size of the table increased to nearly 5 GB. Although the number of files indeed decreased to 24, query performance was slower on the new table, and in the performance metrics, I noticed that the amount of data being read was larger compared to the original table without clustering.

What am I missing here? Why is this happening?

Thanks!