How to control file size by OPTIMIZE

MikeGo
Valued Contributor

Hi,

I have a delta table under UC, no partition, no liquid clustering. I tried

 

 

OPTIMIZE foo;
-- OR
ALTER TABLE foo SET TBLPROPERTIES(delta.targetFileSize = '128mb');
OPTIMIZE foo;

 

I expect to see the files can have some change after above, but the OPTIMIZE returns 0 filesAdded and 0 filesRemoved. By "DESCRIBE detail foo" I didn't see numFiles changed.
Am I missing something? How to make the file size as expected? Are there some conditions to trigger OPTIMIZE to control file size?

Thanks