Help Center> Data Warehouse Service> SQL Syntax Reference> DDL Syntax> CREATE NODE GROUP
View PDF

CREATE NODE GROUP

Function

CREATE NODE GROUP creates a cluster node group.

Precautions

  • CREATE NODE GROUP is the internal interface encapsulated in gs_om.
  • This interface is available only to administrators.

Syntax

1
2
3
 
CREATE NODE GROUP groupname
    WITH ( nodename [, ... ] )
    [ BUCKETS [ ( bucketnumber [, ... ] ) ] ] [VCGROUP] [DISTRIBUTE FROM src_group_name];

Parameter Description

  • groupname

    Specifies the name of a node group.

    Value range: a string. It must comply with the naming convention. A value can contain a maximum of 63 characters.

    A node group name supports all ASCII characters, but you are advised to name a node group according to the naming convention.

  • nodename

    Specifies the node name.

    Value range: a string compliant with the naming convention rules. A value can contain a maximum of 63 characters.

  • BUCKETS [ ( bucketnumber [, ... ] ) ]

    Is designed for internal use of the cluster management tools. You are not advised to use it directly. Otherwise, the cluster may be affected.

  • VCGROUP

    Creates a Node Group used as a logical cluster.

  • DISTRIBUTE FROM src_group_name

    Creates a Node Group to redistribute data in the Node Group specified by src_group_name. You are not advised to use this clause, because it may lead to data distribution errors or Node Group unavailability.

Helpful Links

DROP NODE GROUP

Parent topic: DDL Syntax