Help Center/ Data Warehouse Service/ Developer Guide/ Developer Guide (9.1.1.x)/ DWS GUC Parameters/ Scale-out Parameters
Updated on 2026-07-02 GMT+08:00
View PDF
Share

Scale-out Parameters

enable_cluster_resize

Parameter description: Specifies whether the current session is for redistribution during scale-out.

Type: SUSET

Value range: Boolean

  • on indicates that the current session is for redistribution during scale-out, and allows the execution of specific SQL statements for redistribution.
  • off indicates that the current session is not for redistribution during scale-out., and does not allow the execution of specific SQL statements for redistribution.

Default value: off

This parameter is an internal O&M parameter and applies only to sessions for redistribution during scale-out. Do not set this parameter in service sessions.

enable_auto_insert_into_new_group

Parameter description: Specifies whether to create a new table in the target node group when the INSERT OVERWRITE operation is performed on a table during scale-out. This parameter is available only for clusters of version 9.1.1.100 or later.

Type: USERSET

Value range: Boolean

  • on: The new table is created in the target node group.
  • off: The new table is created in the source node group.

Default value: on

disable_insert_into_newnodes

Parameter description: Specifies whether new tables can be created in the target node group during scale-out.

Type: USERSET

Value range: Boolean

  • on indicates that new tables cannot be created in the target node group during scale-out. By default, new tables are created in the original node group.
  • off indicates that new tables are created in the target node group by default.

Default value: on

This parameter is automatically controlled by the scale-out process. You are advised not to modify it.

Parent Topic: DWS GUC Parameters