@Rocky How to delete an old unused

colocate_group

after dropping all tables from that group ?

SHOW PROC '/colocation_group';

still show the group

In StarRocks, a

colocate_group

is managed automatically. You don't need to (and cannot) manually run a "DROP GROUP" command. The reason the group still appears in

SHOW PROC '/colocation_group';

after dropping your tables is that dropped tables are moved to the Recycle Bin by default. A colocation group is only deleted once the last table associated with it is completely removed from the system. Why it's still there When you run

DROP TABLE <table_name>

, the table remains in the FE's recycle bin for a retention period (default is 86400 seconds, or 24 hours). As long as the table exists in the recycle bin, the colocation group is preserved so that you can

RECOVER

the table if needed. How to delete it immediately If you want to remove the group right now without waiting for the recycle bin to expire, you have two options: 1. Use the

FORCE

keyword (for future deletions) If you haven't dropped the tables yet, or if you want to ensure they are gone immediately:

sql
DROP TABLE <table_name> FORCE;

When the last table in the group is dropped with

FORCE

, the group will be deleted automatically. 2. Wait for expiration or adjust the retention time If you have already dropped the tables, they will stay in the recycle bin. You can check the current retention setting with:

sql
ADMIN SHOW FRONTEND CONFIG LIKE 'catalog_trash_expire_second';

Once that time passes, the metadata will be cleaned up, and the

colocate_group

will disappear from the

SHOW PROC

output. Summary * Automatic Cleanup: The group is deleted automatically when the last table is purged from the recycle bin. * Recycle Bin: Tables stay in the trash for 1 day by default. * Immediate Action: Use

DROP TABLE ... FORCE

to bypass the trash. If you want to bypass the trash. 1 and delete the group immediately. References • using_starrocks/Colocate_join.md

In the mean time can I force this to happen quicker ?