ALTER-COLOCATE-GROUP

ALTER-COLOCATE-GROUP

Name

ALTER COLOCATE GROUP

Description

This statement is used to modify the colocation group.

Syntax:

ALTER COLOCATE GROUP [database.]group
SET (
    property_list
);

NOTE:

1. If the colocate group is global, that is, its name starts with __global__, then it does not belong to any database;

2. property_list is a colocation group attribute, currently only supports modifying replication_num and replication_allocation. After modifying these two attributes of the colocation group, at the same time, change the attribute default.replication_allocation, the attribute dynamic.replication_allocation of the table of the group, and the replication_allocation of the existing partition to be the same as it.

Example

1. Modify the number of copies of a global group

   # Set "colocate_with" = "__global__foo" when creating the table
   
   ALTER COLOCATE GROUP __global__foo
   SET (
       "replication_num"="1"
   );   

2. Modify the number of copies of a non-global group

   # Set "colocate_with" = "bar" when creating the table, and the Database is "example_db"
   
   ALTER COLOCATE GROUP example_db.bar
   SET (
       "replication_num"="1"
   );
   ```

### Keywords

```sql
ALTER, COLOCATE, GROUP

Best Practice