• Data Warehouse Service

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

CREATE NODE

Function

CREATE NODE creates a cluster node.

Precautions

CREATE NODE is the internal interface encapsulated in gs_om. You are not advised to use this interface, because doing so affects the cluster.

Syntax

CREATE NODE nodename WITH
  (
    [ TYPE = nodetype,]
    [ HOST = hostname,]
    [ PORT = portnum,]
    [ HOST1 = 'hostname',]
    [ PORT1 = portnum,]
    [ HOSTPRIMARY [ = boolean ],]
    [ PRIMARY [ = boolean ],]
    [ PREFERRED [ = boolean ],]
    [ SCTP_PORT = portnum,]
    [ CONTROL_PORT = portnum,]
    [ SCTP_PORT1 = portnum,]
    [ CONTROL_PORT1 = portnum ]
  );

Parameter description

  • nodename

    Specifies the node name.

    Value range: A string. It must comply with the naming convention rule.

  • TYPE = nodetype

    Indicates the type of a node.

    Valid value:

    • 'coordinator'
    • 'datanode'
  • HOST = hostname

    Indicates the primary server name or IP address of a node.

  • PORT = portnum

    Indicates the primary server port to which a node is bound.

  • HOST1 = hostname

    Indicates the name or IP address of the standby server of a node.

  • PORT1 = portnum

    Indicates the port number of the standby server to which a node is bound.

  • HOSTPRIMARY
  • PRIMARY = boolean

    Specifies whether the node is a primary node or not. A primary node allows read/write operations. A non-primary node allows only read operations.

    Valid value:

    • true
    • false (default value)
  • PREFERRED = boolean

    Specifies whether the node is a preferred node for read operations.

    Valid value:

    • true
    • false (default value)
  • SCTP_PORT = portnum

    Specifies the port used by the TCP proxy communication library or SCTP communication library of the primary server to listen to the service data transmission channel. It may be a TCP or SCTP port.

  • CONTROL_PORT = portnum

    Specifies the port used by the TCP proxy communication library or SCTP communication library of the primary server to listen to the control data transmission channel. It is a TCP port.

  • SCTP_PORT1 = portnum

    Specifies the port used by the TCP proxy communication library or SCTP communication library of the standby server to listen to the service data transmission channel. It may be a TCP or SCTP port.

  • CONTROL_PORT 1= portnum

    Specifies the port used by the TCP proxy communication library or SCTP communication library of the standby server to listen to the control data transmission channel. It is a TCP port.

Helpful Links

ALTER NODE, DROP NODE