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 routing prefix expressed in quad-dotted decimal representation. Refer to system table |
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
=> CREATE SUBNET mySubnet WITH '123.4.5.6';