CREATE SUBNET

Identifies the subnet to which the nodes of a Vertica database belong. Use this statement when you want to configure import/export from a database to other Vertica clusters.

Syntax

CREATE SUBNET subnet-name WITH'subnet prefix'

Parameters

subnet-name

A name of your choosing to assign to the subnet, where subnet-name conforms to conventions described in Identifiers.

subnet prefix

The routing prefix expressed in quad-dotted decimal representation. Refer to v_monitor.network_interfaces system table to get the prefix for all available IP networks.

You can then configure the database to use the subnet for import/export. (See Identify the Database or Nodes Used for Import/Export for more information.)

Privileges

You must be a user to create a subnet.

Examples

This example shows how to create a subnet.

=> CREATE SUBNET mySubnet WITH '123.4.5.6';