Iceberg file size on dremio

Dremio Cloud
23

@ajay098

Thank you so much for your answer.

I had a similar issue with VACUUM as it did not reduce the iceberg file size at all.

I changed the compression to gzip and voila, it is working.

ALTER TABLE Minio.finance.l0.stockanalysis_balance_sheet_history  SET TBLPROPERTIES (
            'write.parquet.compression-codec' = 'gzip'
             );

Then just do the normal VACUUM and it is WORKING!!!

My Thread: OPTIMIZE and VACUUM table cannot reduce iceberg metadata file size - #8 by Ken

1 Like