Dremio VACUUM TABLE REMOVE ORPHAN FILES command is not supported (Iceberg table)

1

I’m currently using the Iceberg table format with Hive source.

The Expire Snapshots query works fine

VACUUM TABLE hive_source.test_dbt.testdbtdesmergecomplex

EXPIRE SNAPSHOTS older_than = ‘9999-12-31 23:59:59.999’;

Why REMOVE ORPHAN FILES won’t work?

VACUUM TABLE hive_source.test_dbt.testdbtdesmergecomplex

REMOVE ORPHAN FILES OLDER_THAN = ‘2025-12-31 19:43:53.812’;

SQL Error: UNSUPPORTED_OPERATION ERROR: VACUUM TABLE REMOVE ORPHAN FILES command is not supported.

[Error Id: 0438027c-4eaa-4ba7-b832-1e7363a7e6d0 ]

The doc said clearly that it should work!!!

image
image688×152 5.38 KB

Do Expire Snapshots also remove the redundant Iceberg metadata files?

image
image1271×123 6.46 KB

I’m using Dremio 26.0.0 Community Edititon

2

Hey there–

The REMOVE ORPHAN FILES command will be enabled for Dremio Cloud users in the near future.

It will only be go out in Software with the next release. It is not available in Software at the moment.

Dan

1 Like