How to control file size by OPTIMIZE
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-03-2024 10:27 AM
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