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

**URL:** <https://community.dremio.com/t/dremio-vacuum-table-remove-orphan-files-command-is-not-supported-iceberg-table/13169>\
**Category:** Uncategorized\
**Created:** [August 14, 2025, 10:01am UTC](https://community.dremio.com/t/dremio-vacuum-table-remove-orphan-files-command-is-not-supported-iceberg-table/13169 "2025-08-14T10:01:49Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![quangbilly79](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/quangbilly79/32/6549_2.png) [@quangbilly79](https://community.dremio.com/u/quangbilly79)\
**Post date:** [August 14, 2025, 10:01am UTC](https://community.dremio.com/t/dremio-vacuum-table-remove-orphan-files-command-is-not-supported-iceberg-table/13169/1 "2025-08-14T10:01:49Z")

</div>

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!!!

> **[VACUUM TABLE | Dremio Documentation](https://docs.dremio.com/cloud/reference/sql/commands/vacuum-table/)**
>
> When you are working with Apache Iceberg tables, you can use the VACUUM TABLE command to remove older table snapshots that you no longer need and the files (data files, the manifest file, manifest list file, and partition stats files) that are...

 ![image](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/6/63a6b3f9fe5be574b1c42380d0273328fbf1a27a.png)

Do **Expire Snapshots** also remove the redundant Iceberg metadata files?

 ![image](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/7/7b24cc42825abf76780acf15a7e435eba5411a71.png)

I’m using Dremio 26.0.0 Community Edititon

---

<div class="post-metadata">

**Author:** ![danh](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/danh/32/4654_2.png) [@danh](https://community.dremio.com/u/danh)\
**Post date:** [August 19, 2025, 10:06pm UTC](https://community.dremio.com/t/dremio-vacuum-table-remove-orphan-files-command-is-not-supported-iceberg-table/13169/2 "2025-08-19T22:06:30Z")

</div>

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