We enabled liquid clustering on one of the large tables (380GBs). This table goes many operations daily, which improved many folds after liquid clustering. However, after enabling liquid clustering and optimizing it number of files are increased.
Previously it had around 4300 files and now it shows 7900 files. Though table size is almost the same before and after.
It is clustered using two columns which are both in first 32 columns. How can we justify this increase in number of file sizes i.e decrease in data per file.
