• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. SQL Reference
  5. SQL Syntax
  6. CREATE NODE GROUP

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

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

Parameter Description

  • groupname

    Name of a Node Group

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

    NOTE:

    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

  • 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