CREATE SUBNET

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

Syntax

CREATE SUBNET subnet-name WITH 'subnet‑prefix'

Parameters

subnet‑name	A name you assign to the subnet, where subnet‑name conforms to conventions described in Identifiers.
subnet‑prefix	The subnet prefix in either a dotted-quad number format for IPv4 addresses, or four colon-delimited four-digit hexadecimal numbers for IPv6 addresses. Refer to system table NETWORK_INTERFACES to get the prefix of all available IP networks.

You can then configure the database to use the subnet for import/export. For details, see Identify the Database or Nodes Used for Import/Export in the Administrator's Guide.

Privileges

Superuser

Examples