Enable Truncate Operation for Object Storage Disks

Why it matters

This feature allows users to perform the TRUNCATE operation on tables stored on object storage disks, solving the previous limitation where truncation was not supported on such storage. This improves manageability and flexibility when working with large datasets stored in object storage by enabling quick table data removal without dropping the entire table.

How to use it

To use this feature, ensure your table is placed on an object storage disk. Then you can execute the TRUNCATE TABLE statement as usual, e.g.,

TRUNCATE TABLE my_table

This will now work seamlessly with object storage-backed tables.