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 |
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 dbadmin user to create a subnet.
Examples
This example shows how to create a subnet.
=> CREATE SUBNET mySubnet WITH '123.4.5.6';